Slicers not working as expected

[vanweelden]

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

Regards

Marcel

[mussaenda]

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.

[vanweelden]

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?

[mussaenda]

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

[vanweelden]

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

Testfile 

[mussaenda]

Hi @vanweelden ,

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

Hope this helps