Highlight max value in a column of a table

[DMV]

Hello!

I am looking to highlight the max value of a column in a table 

When I use this formula...

MaxValue =

VAR _MaxValue = MAX('Table Name'[Source.Name])

RETURN

   IF(_MaxValue, "Green")

And add it as a condition...

I get every number in the column highlighted.

Since each number in the column is listed multiple times, ultimately I would like to end up with the max number highlighted so I can see all the rows with that number.

Appreciate any input. 

Thanks!

[Callet74]

Hi @DMV 

Try this URL: https://www.sqlbi.com/articles/highlighting-the-minimum-and-maximum-values-in-a-power-bi-matrix/

[FreemanZ]

hi @DMV 

try like:

MaxValue =

VAR _MaxValue = 

CALCULATE(

    MAX('Table Name'[ValueColumn]),

    ALL('Table Name'[Source.Name])

)

RETURN

   IF(_MaxValue, "Green")

[DMV]

@FreemanZ,

Thank you for your response. I tried the solution you provided and I am getting the same results as before. 😕 

[FreemanZ]

hi @DMV 

what would you get if you try:

MaxValue =
VAR _MaxValue =
CALCULATE(
MAX('Table Name'[ValueColumn]),
ALL('Table Name')
)
RETURN
IF(_MaxValue, "Green")

[DMV]

@FreemanZ,

Still getting the same thing. This is really a tricky one!