Forum Discussion

vanweelden's avatar
vanweelden
Frequent Visitor
3 years ago

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

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion

    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's avatar
      vanweelden
      Frequent Visitor

      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's avatar
        mussaenda
        Icon for Community Champion rankCommunity Champion

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