1 of 1 people found this helpful
Have you considered using a conditional color based on a calculated field?
Basically make a field like this and drag it to color,
IF [MyDimensionToWhite] = 'YesWhiteThisOne' THEN 'white' ELSE 'black' END
Hope this helps!
I Just tried it , First of all it is treating as Dimension , But i need measure. Secondly when i drag that to color shelf all other remaining measures color also changes. When i try to format any one measure it all applies to all other measures.
Without looking at your workbook, it is hard to say for sure - but it sounds like you are coloring based on something already, for example SUM([Sales]).
If this is the case - you could do something similar for the label portion.
IF [dontshowthis] = 'yes' THEN '' ELSE [myLabel] END
I have attached the sample workbook, if you open the workbook, you will find an measure 2 column in that column, I don't want to show 15,000,000 and if you observe the total is wrong according to the requirement ( the total is correct according to tableau) , to correct the total i am using the max function which will fix issue of showing the correct sub-total for my requirement .
But i am not able to hide or blank out or white off that column values.
Book10.twbx 19.0 KB
Ah, I see. You won't be able to do that with Measure Values. You can't reference "Measure Values" in a calculated field like you can [Sales], for example.
Best case, you could break this up into multiple views and combine them on a dashboard - then use one of the options up^ to blank it out.