How to just highlight the Max and the lowest cost value in the Tableau table dashboard column
How to just highlight the Max and the lowest cost value in the Tableau table dashboard column. I don't want the whole column to get highlighted, just the max and the min value in red and green color?
Can anyone please help!
My dashboard has a table and one of the column is eCPM, just in this column CPM, I want the $4.41 to highlighted as Green and $7.50 to be in red.
The solution provided works well! But it also applied to my Grand Total, which I don't want. Also I want just eCPM and Market column to be highlighted, because other columns doesn't fit the min/max criteria.
Any help??
Create a calculated field by using the window_max and window_min functions: IF SUM([columnname]) = WINDOW_MAX(SUM([columnname])) THEN "Max" ELSEIF SUM([columnname]) = WINDOW_MIN(SUM([columnname])) THEN "Min" ELSE "Neither" END
Add the calculated field to Color
Manually try to grey out the color of the Neither colors, like so:
