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 plot which I am filtering using a slicer. In that slicer there are blank rows that show up as "blank" in my slicer, those rows contain some visual background data. is there a way to keep those blank rows always selected and hidden from the user? Perhaps dax is needed?
Slicer
----------
blank x
apple
banana
carrot
Solved! Go to Solution.
Hi , @Anonymous
Here is a demo .
If help, try steps as below.
1.create a calculate table
Slicer = FILTER(DISTINCT('Table'[Type]),[Type]<>BLANK())
2. create a measure visual control as below
Visual Control = IF(SELECTEDVALUE('Table'[Type]) in DISTINCT('Slicer'[Type]) || SELECTEDVALUE('Table'[Type]) = BLANK(),1,-1)
3.put the measure into the visual filter pane as below
The result will show as below:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @Anonymous
Here is a demo .
If help, try steps as below.
1.create a calculate table
Slicer = FILTER(DISTINCT('Table'[Type]),[Type]<>BLANK())
2. create a measure visual control as below
Visual Control = IF(SELECTEDVALUE('Table'[Type]) in DISTINCT('Slicer'[Type]) || SELECTEDVALUE('Table'[Type]) = BLANK(),1,-1)
3.put the measure into the visual filter pane as below
The result will show as below:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Possibly, you filter out blanks in your slicer and write a measure like:
Measure =
VAR __Selected = SELECTEDVALUE('Table'[Slicer])
RETURN
SUMX(FILTER(ALL('Table'),[Column] = __Selected || ISBLANK([Column]))
Obviously I have no idea exactly what you want so this is a concept I am conveying here. If you want something more concrete, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |