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.
I have a slicer which states A & B.
I want the set target to show when I'm selecting a single option, for example if I select the A in slicer the target measure should say 90, 45 for the option B. Now i've simply using the total target of 135 with the simple target measure. Can someone please help me with this? how to split them and with the options and also is it possible to show both combined?
Thanks.
Solved! Go to Solution.
@Preetham909 , Create a target table with two rows
A 90
B 45
Then you can simply use Sum(Target[Value])
or have measure
if(not(isfiltered(Table[Cat])) , 135, if(selectedvalue(Table[Cat]) = "A", 90, 45 ))
@Preetham909 , Create a target table with two rows
A 90
B 45
Then you can simply use Sum(Target[Value])
or have measure
if(not(isfiltered(Table[Cat])) , 135, if(selectedvalue(Table[Cat]) = "A", 90, 45 ))
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |