Forum Discussion
Remove Blanks From New Filter Experience Preview
I would also like to hide the blank option in the filter pane without changing the underlying data. The blank data is related to another table that does not have all the fields, therefore in my visual they properly do not display. I would like to not show the blank option to the public. Is this possible? Or do I need to use slicers instead of the filter pane?
Its definitly possible to not show the blank to your end users. Just follow these directions:
(This is for the new power bi desktop version, if you dont have that version you'll need to do the same thing - but in the filter pane)
1) In the new filter experience under your filter, click Select all and then unselect the blank
2) click on the lock filter (looks like a lock, it should flip from unlocked to locked)
Then when you upload to the web service, no one will see the blank option. They can still filter/ unfilter on the remaining options
Thank you Anonymous . The process worked. However, the unselecting of the (Blank) removes the measure that has some fields that are blank from showing up when I select any of my other filters. I have measures on one visual from the two tables in a line chart. The purpose is to compare our data with other campuses data. Any way to hide without filtering out?