Forum Discussion

tex628's avatar
tex628
Community Champion
8 years ago
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...
Need Help
  • praiselyabraham's avatar
    praiselyabraham
    8 years ago

    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.

praiselyabraham's avatar
praiselyabraham
Resolver II
8 years ago

Here the final target measure is acting as a flag , 

in the earlier scenario, it was made a 2 state flag that had either 1 or 0 value.

 

In this case , try to make the final target measure make it a multi level flag on the various scenarios that you have,That way you can define the mentioned case.

 

 

tex628's avatar
tex628
Community Champion
8 years ago

Ohh, I understand. 

Thank you for the assistance! :)