Skip to main content
cancel
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

Reply
vanweelden
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

Regards

Marcel

5 REPLIES 5
mussaenda
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

 

mussaenda_0-1685014135549.png

 

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

 

Testfile 

Hi @vanweelden ,

 

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

mussaenda_0-1685073699321.png

 

Hope this helps

 

Helpful resources

Announcements
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