Forum Discussion
Slicer with an hierarchy
Hi Anonymous ,
There are many levels to this issue. The "blank" might be there because there is data below that in the hierarchy. For example, I have a slicer with Country, Region, District. If I look at it at only the first two levels, I see blanks:
But, if I remove the "blank" then I am removing data - because I have level three's that are not associated (and are therefore under "blank")
Therefore, just removing "blank" from the slicer will remove lots of options.
The best choice is to structure your data so that it is consistent throughout.
You could always use the filter and remove the "blank" but that will have a strong possibility of causing you data issue.
Yo ucan alsow watch this video for some help:
(126) Why is there a blank in my Power BI slicer??? - YouTube
Super UserHi Anonymous ,
There are many levels to this issue. The "blank" might be there because there is data below that in the hierarchy. For example, I have a slicer with Country, Region, District. If I look at it at only the first two levels, I see blanks:
But, if I remove the "blank" then I am removing data - because I have level three's that are not associated (and are therefore under "blank")
Therefore, just removing "blank" from the slicer will remove lots of options.
The best choice is to structure your data so that it is consistent throughout.
You could always use the filter and remove the "blank" but that will have a strong possibility of causing you data issue.
Yo ucan alsow watch this video for some help:
(126) Why is there a blank in my Power BI slicer??? - YouTube