Power BI
Needs VotesAllow option to remove "Blank" from slicer if data used contains no blank data.
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)
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.