Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there, I tried to use conditional formatting to display the min and max values of a measure in a table. Like the one in table below which highlihghts value in green for max and min in red in a row.
This is what I got so far with Internal hire total being a measure.
Solved! Go to Solution.
Hi @Anonymous use the below measure and use it inside the conditional formatting pane to get the results.
Measure = var rnk1=rankx(allselected(particulars),yourmeasure,,desc)
var rnk2 = rankx(allselected(particulars),yourmeasure,,asc)
return if(rnk1=1,"Green",if(rnk2=1,"Red"))
This will surely work, please mark this as solution if this works fine with you.
Thanks.
@Anonymous , Try one of the two
FormatMeasure =
VAR SelectedTable = ALLSELECTED('FACT_Movement')
VAR SelectedTotal = CALCULATE(COUNT('FACT_Movement'[Employee ID]))
VAR MaxCount = CALCULATE(MAXX(VALUES('FACT_Movement'[Type of Move]),[Internal Hire total]),ALLEXCEPT('FACT_Movement'[Type of Move]))
VAR MinCount = CALCULATE(MINX(VALUES('FACT_Movement'[Type of Move]),[Internal Hire total]),ALLEXCEPT('FACT_Movement'[Type of Move]))
VAR MovementTotal = [Internal Hire total]
RETURN
SWITCH (
TRUE(),
MovementTotal= MaxCount, "GREEN",
MovementTotal=MinCount,"Red" )
or
FormatMeasure =
VAR SelectedTable = ALLSELECTED('FACT_Movement')
VAR SelectedTotal = CALCULATE(COUNT('FACT_Movement'[Employee ID]))
VAR MaxCount = CALCULATE(MAXX(VALUES('FACT_Movement'[Type of Move]),[Internal Hire total]),ALLEXCEPT('FACT_Movement'[GENDER]))
VAR MinCount = CALCULATE(MINX(VALUES('FACT_Movement'[Type of Move]),[Internal Hire total]),ALLEXCEPT('FACT_Movement'[GENDER]))
VAR MovementTotal = [Internal Hire total]
RETURN
SWITCH (
TRUE(),
MovementTotal= MaxCount, "GREEN",
MovementTotal=MinCount,"Red" )
Hi @Anonymous use the below measure and use it inside the conditional formatting pane to get the results.
Measure = var rnk1=rankx(allselected(particulars),yourmeasure,,desc)
var rnk2 = rankx(allselected(particulars),yourmeasure,,asc)
return if(rnk1=1,"Green",if(rnk2=1,"Red"))
This will surely work, please mark this as solution if this works fine with you.
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |