Reversed KPI Conditional formatting

[Anonymous]

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

[Anonymous · Accepted solution]

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.