Distinct KPI target depending of filter selection

[MikelPC]

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!

[mbauer]

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

[Datatouille · Accepted solution]

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]

It works perfectly Well!

Thanks!