Forum Discussion
Slicers - Blank Values when published - September 2016
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.
Anonymous I get the blank item even in a table where it's just unique items for the slicer column. The Sales Rep table has two columns: Name and ID#. No blanks in either one. But when that's connected to another table and used as a slicer, (Blank) shows up again.
Anonymous: did you drag the column to the Report level filters and unchecked (Blank) ?
Anonymous yeah I can work around this but I have to do that with every slicer in every report. If there are no blank values in the column I'm using as a slicer there should be no blank value in the slicer, plain and simple. This is yet another blank bug in Power BI. They love to display blanks where they shouldn't. A new unnecessary and unwanted blank shows up with every monthly release.
Anonymous: Agreed. However, this will probably not be a prob in the coming weeks/months.