Showing results for 
Search instead for 
Did you mean: 
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

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors