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.
Hi,
I'd like to have a slicer that can select all the lines when the value of the blue lines is not 0
if anyone can help
thanks
Solved! Go to Solution.
Hi, @JVIR
According to your sample matrix visual, I’ve also created some test data to create a similar matrix as yours and use a measure to achieve your requirement, you can take a look at my steps:
This is the original matrix I created:
MtDiff1 =
var _sum=CALCULATE([MtDiff],FILTER(ALL('Table'),[ID]=MAX([ID])))
return
IF(
SELECTEDVALUE(Slicer[Do you want to display the data which the blue lines is 0])="No",
IF(_sum=0,BLANK(),[MtDiff]),
[MtDiff])
And I can achieve what you want.
You can download my test pbix file below
If this result is not what you want, you can post some sample data or your sample test pbix file(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @JVIR
According to your sample matrix visual, I’ve also created some test data to create a similar matrix as yours and use a measure to achieve your requirement, you can take a look at my steps:
This is the original matrix I created:
MtDiff1 =
var _sum=CALCULATE([MtDiff],FILTER(ALL('Table'),[ID]=MAX([ID])))
return
IF(
SELECTEDVALUE(Slicer[Do you want to display the data which the blue lines is 0])="No",
IF(_sum=0,BLANK(),[MtDiff]),
[MtDiff])
And I can achieve what you want.
You can download my test pbix file below
If this result is not what you want, you can post some sample data or your sample test pbix file(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks for your help. It works perfectly 😊
okay when you say select all the lines do you mean only show the lines where the value > 0?
whata is the measure name being used where it is 0? you have 2 columns showing there.
Proud to be a Super User!
Yes all the lines <> 0
measure name is MtDiff
thats so small can barely read it.
Proud to be a Super User!
sorry
I changed the size
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 |
---|---|
96 | |
95 | |
80 | |
74 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |