Forum Discussion
KPI Card Colour Coding with Multiple Goals
I'm currently working on a KPI visual with two goals: the budgetted value & the value from the previous year. The previous year's value was calculated with a measure. Power BI has automatically colou...
Hi,
You may not have given me the exact solution I was looking for, but you put me on the right track so thanks for that! I eventually managed to solve it by creating a measure:IF([ ACT]>[Target ];"Green";"Yellow")
I added this to conditional formatting on the neutral value and it seems to have worked so thanks for the inspiration.
This is an example of one of the snapshots with the wrong colour coding.