Forum Discussion
Remove Blanks From New Filter Experience Preview
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?