Forum Discussion
Solved
KPI Visual
Hello, I've got a large KPI report. The report produces three sub-scores that together create a final score. The scores range from 0-5. When a score is under 1 the value will turn red. Thi...
Hi ,
As per my understanding, if any of the KPI has has a red indicator i.e. value below the tqarget, the final kpi should also be shown in red.
For this i created a measure that shall verify all the other measure. In your case:
final target = IF(OR(OR([Value1]<3,[Value2]<3) ,[Value3]<3),0,1)
I used advanced cards, and used this measure in the condition field to check if the value is 0 , then show it in red.
Attaching the screenshot of it.
Hope this solves your issue.
Regards.
tex628 is the kpi selection dynamic or you have 4 kpi's? Could you post screenshots n sample data?