Forum Discussion
Reversed KPI Conditional formatting
Hi everyone,
in my Matrix visual i have 5 KPI's. 4 of them are "normal" and one is reversed what means that it's better to have that KPI lower rather than higher.
How to do conditional formatting with that KPI? All other KPI's show green arrow when they are above value i.e. higher than previous month value, and that reversed KPI should be green if it's under previous month value.
In this picture below I need to get these 25,2% to be marked with red arrow.
I hope someone can find a solution.
Kind Regards
Hi Anonymous
You can use measure to format the icon.
e.g
1.Sample data
2.The format measure
Measure = var a=CALCULATE(SUM('Table'[KPI]),OFFSET(-1,,ORDERBY('Table'[Month]))) return IF(SUM('Table'[KPI])>a,1,0)Then put the measure to the conditional formatting
Output
The logic is that use measure to find the last month KPI first, then compare it to KPI of the current month
If the current KPI is less than last month , then set number 1, else 0.
You can refer to the attachment below.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous
You can use measure to format the icon.
e.g
1.Sample data
2.The format measure
Measure = var a=CALCULATE(SUM('Table'[KPI]),OFFSET(-1,,ORDERBY('Table'[Month]))) return IF(SUM('Table'[KPI])>a,1,0)Then put the measure to the conditional formatting
Output
The logic is that use measure to find the last month KPI first, then compare it to KPI of the current month
If the current KPI is less than last month , then set number 1, else 0.
You can refer to the attachment below.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.