Forum Discussion
KPI Visual
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?
Here is a sample file. The aim here is to have the final score visual become red due to the fact that one of the subscores is below 1.0 in score.
Essentially if one of the subscore is red the final score should also becore red.
https://drive.google.com/open?id=1U7AAwM-2ACx1sZvUbUwvcBam0dFT4H-r
