Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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 !
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
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 !
It works perfectly Well!
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |