topic Re: Slicers not showing all data in Developer

Slicers not showing all data

apurvashrestha2 — Thu, 30 Dec 2021 17:18:47 GMT

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.

Re: Slicers not showing all data

dm-p — Fri, 31 Dec 2021 04:20:01 GMT

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

Re: Slicers not showing all data

Anonymous — Tue, 04 Jan 2022 06:38:36 GMT

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 Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.