For this exmaple I used 5 as my zero point since there are no negative numbers.
In added +/- signs in sheet3 by first converting to a string. It's not a great solution for a couple reasons: you lose the ability to show totals, there are issues with formatting as currency, and it isn't particularly easy to see at a glance which values are negative. If showing +/- signs is really your goal you can probably find workarounds, though perhaps some quick conditional formatting like in sheet 4 is a better solution.
Example.twbx.zip 56.0 KB
Thank you very much Dylan! This is great!
20 of 20 people found this helpful
It's not necessary to convert to a string:
1. Drag a measure value to the Text display on a worksheet.
2. Right click on the measure value, and from the menu that appears, select "Format".
3. In the "Numbers:" drop down box ( the "Numbers:" drop down box appears in the left-hand pane after selecting "Format"), select "Custom".
4. Paste the following Custom format in the box: "+" #,##0.00%;"-" #,##0.00%; (this example is for a percent)
If you would not like your measure to be displayed as a percent, then remove the percent sign from the Custom format. If you would like to show more or fewer decimals, then remove or add accordingly from the Custom Format as well.
Custom format is definitely better than converting to text, in my opinion.
Thanks for your reply - really helped me out. Question though - when I use this custom formatting, the zero value doesn't show up at all. How can I make sure that the zero value shows up as "+0.00%"?
1 of 1 people found this helpful
Oh never mind! Figured it out 2 minutes after asking this question. The solution would be to use this format:
"+" #,##0.00%;"-" #,##0.00%; "+" 0.00% - since Tableau shares the same custom formatting rules as Excel.