Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Slicers not working as expected

Hello All,

I have build a P&L model where i can select the different companies (BdNr) with a slicer.

I expect that when i select a company the slicer wit the different Profit Centers (Omschrijving) will only let me see the Profit Centers that belongs to this company. But that doesn't happen.

So when i select Company 1132, the next slicer will only show me the Profit Centers (PC16/PC17/PC18/PC19).

Is that the way i build my model? Is there a solution for this?


Here is my testfile: Testfile 


Thank you in advance



Super User
Super User

Hi @vanweelden ,


There is a solution for your requirement, what we usually do, we filter the slicer using a measure where for e.g., the amount is not blank or not 0.


Then it will be filter as per your requirement.


Hi @mussaenda 

Thank you for your reply. How will that be implemented in my model?

I believe in Power Pivot this is not so easy?


I wanted to do it on your testfile but i am not able to download




Ok, i tried my personal onedrive. Does this one work?



Hi @vanweelden ,


On your slicer, right click, then check this box.



Hope this helps


Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors