Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I want to remove blanks from my Slicers. Previously i had an option to remove this. But now i cannot. Can this be acheived now?
Thanks,
Siddarth
Solved! Go to Solution.
Hi There,
You can use this technique. Drag your field onto the canvas and Select the Visual in which you can filter the blank value using page level filters and then change that visual to the slicer. That's it.
This is quick and easy.
Thanks & Regards,
Bhavesh
@siddarth_mine You can do that by using page-level or report-level filters. Use that filters to filter out blank or null values.
hi. there is very nice solution:
I've worked around this by using a table instead, using your field as the Values. You can format the table to make it look like a list and add a title or change your column name to something akin to "Choose a Category." Unfortunately the check box wouldn't be available.
https://www.dropbox.com/s/u5jxwkj8t3azbuy/Slicer_Example.jpg?dl=0
This needs to be added back to Power BI functionality.
Report and page data needs to show the values within the BLANK record but the Slicer needs to have BLANK removed.
BLANK anywhere gives the user digesting the data a sense of doubt in the accuracy.
I've had to use the +0 method in almost all of my visuals in all of my Power BI projects and this is another instance where it's causing extra work for me.
I have did a work around to hide BLANKS from the slicers only. This might not work for dynamic slicer values, in my case the slicer values will not change. I had to duplicate the slicer, select all values except Blank and hide the slicer. With Edit interactions options, I have turned off everything from this slicer but the original slicer so other visuals are not impacted by removing the blank values.
Great work around, but how horrific to have to have 2 slicers on the page for every one you need.
Come on MS, this is a huge unforced error. Please fix micky mouse stuff like this.
Kudos to you
You saved my day
This for the suggestion..this worked like a charm..Kudos!
Is there a way to hide the blank values but not filter out the data?
For example:
I have a column with binary values "Yes" or "No" but I want the slicer to just have the "yes" option showing. I do not want to filter out the NO data though. So the slicer would be selecting either ALL DATA or Data with YES in that column. I can elaborate if needed! Please help 😞
Another way to get rid of the "(Blank)" is to:
I second this question.
The answer is no. A slicer is a filter, so hiding something from the slicer is filtering it. If it is deselected in the slicer, by definition it is filtered out. If it isn't shown in the slicer, it can't be selected. So hiding and filtering are the same thing.
Proud to be a Super User!
@siddarth_mine You can do that by using page-level or report-level filters. Use that filters to filter out blank or null values.
Please note that filtering a visual and then changing back to a slicer doesn't work with the version of Power BI I am currently using, so this is only appropriate in some scenarios.
@RhysMno scenarios. This is out of date advice. They made changes to the slicer visual in...November I think. The switch visual types trick no longer works. You have to use the page or report level filter.
Proud to be a Super User!
Filtering in the 'page level filters' does the trick.
Use the advanced filtering option "is not blank" in stead of the basic filtering, to be sure to include future changes in the data.
Filtering in the 'page level filters' does the trick.
Use the advanced filtering option "is not blank" in stead of the basic filtering, to be sure to include future changes in the data.
Hi There,
You can use this technique. Drag your field onto the canvas and Select the Visual in which you can filter the blank value using page level filters and then change that visual to the slicer. That's it.
This is quick and easy.
Thanks & Regards,
Bhavesh
NO this is not quick and easy, because I do not want to filter my page. I want to filter my slicer.
My slicer is looking at Case statements in SQL, and the visual is looking at the base column of these Case statements. So the visual will never have a null, but the slicer is looking at different columns, and will have a null.
I am doing this to break my slicer in two in order to save space.
There needs to be a way to do this
User | Count |
---|---|
139 | |
70 | |
67 | |
52 | |
52 |
User | Count |
---|---|
210 | |
92 | |
64 | |
59 | |
56 |