I'm new to Tableau and got struck in this conditional formatting issues over a period of time. Expecting some supports from you guys
We have SSAS OLAP cube as our data source, in a scenario we need our dimension to be conditionally concatenated with a '%' symbol (Please find the attached Screenshot-1 for clarifications).
The Screenshot-1 illustrates an example in which:
We want data for ‘P%’ to always be displayed in ‘%’ value i.e 8%, 2%...., 189.76%, 105.69%....25%, 6%...etc. as you can see, for Measure Name DEF, the values are displayed in % by default from the Cube.
Note : In the attached screenshot,
1. Measure Names, Calculation and Week Ending are from the Dimension section
2. ‘ABC’, ‘DEF’ and ‘GHI’ are values in Measure Names. And ‘A’, ‘K’, ‘P%’ are values of Calculation field.
Similarly, we need our concatenated data to be displayed in different colors based on some range of values
We want data for ‘P%’ to always be displayed in different colors based on different values. E.g For all P% > 0 , Green color, P% < 0 to -10, Red Color…etc
We used the formulae, color and legend options to achieve this. However, our solution applies color formatting to all values of Calculations and not just ‘P%’.
In short: How can we restrict the % display to only ‘P %’