Forum Discussion

MikelPC's avatar
MikelPC
Frequent Visitor
9 years ago
Solved

Distinct KPI target depending of filter selection

Hello,  I'm new here and apaologize if this question appeared before, I van't find it here.   My question is:  I have a costs graphic, and my objective is that when I select the type 20 on the fi...
Need Help
  • Datatouille's avatar
    Datatouille
    9 years ago

    Hi MikelPC 

    Try this measure

    Switcher = If( HASONEVALUE(YourTable[SlicerColumn]) , SWITCH(VALUES(YourTable[SlicerColumn]) , 20 , 0.5 , 30 , 1.5 ) , "Please choose a single value for the 'TipusNoConformitat' slicer")

     

    And place it in the 'target goals' section of your graph !

mbauer's avatar
mbauer
New Member
7 years ago

Hello,

 

My KPI indicator updates based on the filter selected from another graph but the target goal remains as a total. Is there a way to have the target goal update as well based on the filter selected?

 

 

Thanks,

Madeline