Forum Discussion
KPI Conditional Formatting Not Correct
A KPI I created for a measure doesn't conditionally format appropriately and I don't understand why. The KPI has the correct value of 85.51% but doesn't get coded as GREEN like it should. However, ...
After digging into the measure a bit more, it appears that the conditional formatting criteria is including both 2020 and 2021 data so the KPI formating is .9276 and not the .8551. Why would this happen? I can't figure out how the measure is calculating wrong.