Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a matrix showing a YTD measure. A single select slicer to select the date until which the matrix should so data.
Now the user wants a TRUE/FALSE kind of slicer to be able to show only rows in which the current data has data (so NOT(ISBLANK([Measure])) ). I am able to do this directly on the matrix by adding a filter on field (measure) [Measure] with "is not blank". However, I have no idea how to accomplish this so the user is able to toggle it themselve.
Link to a .pbix example:
Solved! Go to Solution.
Hi @MennoHoogeveen ,
Here are the steps you can follow:
1. Enter Data – create a table.
2. Create measure.
Flag =
var _select=SELECTEDVALUE('Slicer_Tabel'[Flag])
return
IF(
_select="Flase"&&[Measure]=BLANK(),0,1)Flag =
var _select=SELECTEDVALUE('Slicer_Tabel'[Flag])
return
IF(
_select="Flase"&&[Measure]=BLANK(),0,1)
3. Place [Flag]in Filters, set is=1, apply filter.
4. Result:
Select True:
Select Flase:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @MennoHoogeveen ,
Here are the steps you can follow:
1. Enter Data – create a table.
2. Create measure.
Flag =
var _select=SELECTEDVALUE('Slicer_Tabel'[Flag])
return
IF(
_select="Flase"&&[Measure]=BLANK(),0,1)Flag =
var _select=SELECTEDVALUE('Slicer_Tabel'[Flag])
return
IF(
_select="Flase"&&[Measure]=BLANK(),0,1)
3. Place [Flag]in Filters, set is=1, apply filter.
4. Result:
Select True:
Select Flase:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Worked perfectly, thank you!
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |