Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow option to remove "Blank" from slicer if data used contains no blank data.

Vote (23) Share
's profile image

on 17 Jan 2017 14:03:21

There is a glitch or bug that display a "Blank" option for slicers that is pulling data from a list that contains in fact no blank data. There should be an option to remove this blank option from being selected. It looks very amateur to present the slicers I have with a blank option to be selected and then it only lead to a blank display because there is no blank data actually to be represented.

I understand a user previously has suggested a work-around for this bug to first start with a visual display and exclude the data and then switch to slicer--but that method doesn't work for my case, and rather than having to work-around a bug, the bug should be fixed.

Thank you.

Comments (1)
's profile image Profile Picture

Shamsu Zoha on 05 Jul 2020 23:09:49

RE: Allow option to remove "Blank" from slicer if data used contains no blank data.

I am also facing the similar issue. In my dim table its has only 2 records.
If I am not joining my dim table with other facts table, then slicer is displaying those 2 records.
But when I join the dim table with other facts table, the slicer is displaying "Blank" with other 2 data.
Any solution around this will be most welcomed.