Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |