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 filter, the target for KPI must be 0,5 and when I select the type 30, the KPI it will be 1,5.

 

Thank You!

 

 

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 !

3 Replies

  • Datatouille's avatar
    Datatouille
    Icon for Solution Sage rankSolution 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!

  • 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