Forum Discussion
Community ChampionKPI 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.
Resolver IIHi ,
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.
Community ChampionThis worked, just as you said! :)
But i have a followup question regarding the "Advance card" visual.
How does the visual know which value to look at when calculating conditions?
I have 3 conditions directed towards the summary measure and 1 directed to the final target measure. But nowhere in the visual do you specify towards which value the condition should look?
Sorry this is messy :) Hope u understand what i dont!