6 Replies Latest reply on Sep 21, 2016 6:02 PM by c w

# How to highlight the Maximum Values in each row?

I created a data table with distinct count of IDs in each month. The table automatically updates the recent N months data every day.

My next step is to figure out  the maximum value in each row as every day goes by and highlight the number. Anyone can help?  Thanks!!!

• ###### 1. Re: How to highlight the Maximum Values in each row?

Hi there! The simplest solution would be to drop your measure onto the color marks and then just use the difference in colors to indicate the maxima.

If that isn't enough, then you could use table calculations to color just the highest value. Let me know if you want me to explain that. (And please let me know how familiar you are with table calcs.)

• ###### 2. Re: How to highlight the Maximum Values in each row?

Thanks for your reply. I just started to learn Tableau not long ago. Could  you please explain more in detail? How to return the max value in each row within each year from the window? Thanks!

• ###### 3. Re: How to highlight the Maximum Values in each row?

Here's an example: let's say that I'm showing the sum of sales. I can take Sales and drag it on top of the Color mark and here's how it looks:

• ###### 4. Re: How to highlight the Maximum Values in each row?

Hi I actually want the Max value to be highlighted across the pane. And other values remain the same color. I figured out the calculation. (below) Thanks for the inspiration!

if [distinct count UOF No] = window_max([distinct count UOF No],first(),last())

then "color"

else "none"

end

• ###### 5. Re: How to highlight the Maximum Values in each row?

but there is another issue:After I created the calculation field as mentioned previously and dragged it to the color pane,  the color selection does not have  "black" . The closest color I can choose for the font is grey. Do you have any idea? Thanks.

• ###### 6. Re: How to highlight the Maximum Values in each row?

oh. I got it. there is a drop down list there. Thank you!!