Horizontal Conditional Formatting in Matrix Visual

[Dhrutivyasa-070]

Hello, 

i need to apply conditional formatting in matrix visual in powerBI (top 3 value in each rows).

I Tried top n in dax but it did not worked for me . 

ex- below snapshot for refrence

Thanks in advance.

Dhruti

[ppm1 · Accepted solution]

Here's a measure expression that shows one way to do it. Just use this measure as the Field for conditional formatting for the measure in the matrix visual. Note that if you have a sort-by column on your month, you'll need to include that in the measure too.

Top3MonthColor =
VAR thismonth =
    MIN ( 'Date'[Month] )
VAR top3Mos =
    TOPN ( 3, ALLSELECTED ( 'Date'[Month] ), [Total Qty], DESC )
RETURN
    IF ( thismonth IN top3Mos, "Light Green" )

Pat