Hi All,
How to color code a dimension? The %Diff is a column to be shown at the exact column 5 in the tableau report. The column %Diff is a measure value and this has to be the dimension which i have converted but not able to color it the way as it was displayed in the Excel report. And this requirement from my bosses is not changeable.
Regards,
Srinivas
Can you talk more about Input available and output needed? Can't just assume things.
Hi Srini,
Are you looking for this one???
IF SUM([Profit])<0 then "green"
ELSE "Red"
END
Thanks and Regards,
Ashish Chaudhari
No I am looking for this.
The format should be maintained and columns places has to be retained which has to be in the same location.
The same has been achieved but the format is what restricting me
Regards,
Srini
What about this one?
I am just referring to the screenshot that you have shared. I am still unable to get what output is needed.
No Ashish, Thank you for the quick respoinse.
After this measure is brought into, can we restrict the other measure(s) without the color coding ?
Hi Srinivas,
This could help you.Attaching the workbook.
Refer the link as well Conditionally Formatting Cell Background Color | Tableau Software
Hi Srini,
You can still do that. You need to keep all the metrics in the row section and make them discrete and the one which you need color code put it into the label shelf.
Then put the calculated field that I have created in the color section and its done.
Check the output.
Thanks and Regards,
Ashish Chaudhari
Hi Srini,
Did you got solution?
Check the below one..this might help you!!!
