Forum Discussion
Remove Blanks From New Filter Experience Preview
I am using two datasets that contain a common business area code. However, to use the new filter experience preview I created a new dataset exclusively for the business area so it could be my singular filter. In doing so, my filter shows an option of blank even though the table that I created does not have blank rows. Is there a way to remove blank as an option from the new filter experience? I tried to select all except the blank under the visualizations pane then under report level filters, but then it only gives m the option of "Select all, not blank." Rather I'd just prefer the lank option be gone as to avoid questions. Any suggestions? I am assuming it has to do with how I created my dataset.
6 Replies
- Hi Anonymous,
Is the new dataset compose of values from the two dataset of bussines unit?
How are the relationship made between the tables?
Be sure to use the table with unique valies as your filter and not one of the other tables.
Regards,
MFelix Hi Anonymous,
I'd like to suggest you to take a look at following link to know why this blank item displayed:
Slicer showing Blank as a value when data does not have any blank values
Regards,
Xiaoxin Sheng
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?
