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 !

Datatouille's avatar
Datatouille
Solution Sage
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 !

MikelPC's avatar
MikelPC
Frequent Visitor
9 years ago

It works perfectly Well!

 

Thanks!