Forum Discussion
Slicers - Blank Values when published - September 2016
The September release seems to be adding Blank Values into Slicers when published. They are OK in the Desktop version, and the workaround of creating a Table first and seting Visual Level Filters to Is Not Blank is no longer working when published. I have only noticed the problem in this new version. Has anyone else come up with a work around? Thank you!
12 Replies
As I tested in Power BI Desktop (2.39.4526.362 64-bit), it always adds "Blank" item Slicer. But setting Visual Level Filters to "Is Not Blank" only works for numeric field. But for text field, it still shows black values in visual even you set Visual Level Filters to "Is Not Blank". I suggest you remove the blank rows in Query Editor or create a calculated table with blank rows filtered.
Regards,
@KHorseman same problem: with previous version I was able to hidden blank value with filters workaround, but with september release I can't do it anymore :smileyfrustrated:
Will be the problem resolved with october release?
This (Blank) thing on slicers really bugs me but here's a silly and stupid workaround:
In Power BI Desktop.
Create a new table with "Enter Data". Name the table the same as the column you're slicing.
First column should have the same name as the column you're trying to slice. In that column, type in all the unique values manually. Then create another column for your desired outcome. It can be whatever values you want really, even the same as in the first column.
Load this table and mow make sure this has active relationship with the original column you want to slice.
Now slice the original column and drag the new table to
Then drag the new table to the report level filters and uncheck (Blank).
Ps. If you have many unique values in the column you want to slice, consider creating another query for that instead of manually typing all results.
