1 of 1 people found this helpful
Darius, as long as you're only looking for 2 different number formats, Zach Leber came up with this very clever way to switch the format using the positive/negative custom number format. I couldn't find his original post but I saved his workbook (see attached). It's a little hard to see what's going on at first, here's a shot of the calc field, note the negative signs:
Then he puts this on the label shelf and uses a custom number format:
He's doing % for positive numbers, and normal formatting for negative numbers. One warning: this doesn't work if you have negative values in your data set.
That Zach Leber is a very clever guy! Enjoy his work.
Thanks for the quick response.
This ALMOST helps. The issue with this is that the 2nd type of axis (negative) comes upside down!!!!! I.e. starts at 4,000,000 and the top ends up being 0!
Unfortunately the axis in the example is long-lat. It's not based on the actual metric!
Thanks though - very close try!!!
Zach's concept can work in a lot of different situation that have nothing to do with lat-long. Provide samples of your metrics and I'll be glad to show you how to make his concept work. (Assuming none of your data has negative values.)
Darius, you're absolutely right this technique doesn't work in your situation. You might be able to set this up as two different sheets and then use dashboard actions to switch between the two. Not sure how the switch will look, haven't tried this myself. Sorry, I couldn't be of more help.
Mate no worries - thanks a million for giving it a shot!!!!!!!! Really apreciated.
I have a Tableau open day here in Sydney on Friday so maybe I'll ask them there if I get a chance to speak to someone