Forum Discussion
Slicers not showing all data
I have two columns in my slicers. If I add just one column, the data is shown correctly (blank, false & true). If I add another column in the slicer, true option vanishes although the records with true value exists in the power BI. Please find the image below for reference.
Hi apurvashrestha2 ,
I see you have blank in your slicer. Is your problem that True part will disappear from your hierachy level slicer?
I think there is no down level data in True in your data model. In my sample I can reproduce the same problem like yours. True part will disappear when I expand it.
Try to enable "Show items with no data“ in value field.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi apurvashrestha2,
If you add multiple fields to a slicer, it becomes a hierarchy. If you want to manage the display of unique values of both columns, it's probably better to add them as two separate slicers.
If you need the hierarchy for these fields, do they relate correctly through your model and is the filter direction correct for any relationships?
Regards,
Daniel
Hi apurvashrestha2 ,
I see you have blank in your slicer. Is your problem that True part will disappear from your hierachy level slicer?
I think there is no down level data in True in your data model. In my sample I can reproduce the same problem like yours. True part will disappear when I expand it.
Try to enable "Show items with no data“ in value field.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
