Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having trouble trying to get the right limit set on conditional coloring on a KPI. My KPI is calculating the number of errors from the previous month using the following measure:
Sum({<[Month]={'$(vMonthPrevious)'}>}[Errors])
Now I wanted to add a limit to color the value Red if the percentage of errors is greater than 0.001 (e.g. 1/1000). The following measure returns the percentage but now I need to color based on that percentage being greater than 0.001:
=Num(Sum({<[Month]={'$(vMonthPrevious)'}>}[Errors])) / Num(Sum({<[Month]={'$(vMonthPrevious)'}>}[Transactions]))
Any help would be appreciated. Thanks!
Hi
In your KPI object you should have this for conditionnal color
just Try to put 0.001
It didn't seem to work. I actually made it 0.03 to try to get it to employ the conditional formatting - but no success. See attached.