Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Mar 29, 2019, 3:32 PM

What is the custom number format for showing 0% as hyphen and for all other values show with percentage?

Can I replace 0% with a hyphen -

What is the custom number format for showing 0% as hyphen and for all other values show with percentage?

2 answers
  1. Don Wise
    Mar 29, 2019, 4:49 PM

    Hello Manoj,

     

    Tableau allows you to CUSTOM FORMAT your percentages just as in MS-Excel, where the first format is for positive %; the second is for negative %; and the last is for no change or 0%:

     

    0.00%; 0.00%; -

     

    Give it a try!  Best, Don

    Hello Manoj, Tableau allows you to CUSTOM FORMAT your percentages just as in MS-Excel, where the first format is for positive %; the second is for negative %; and the last is for no change or 0%: 0.

Write an answer...
0/9000