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)...
Need Help
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
3 years ago

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
    3 years ago

    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
      3 years ago

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

       

       

      • vanweelden's avatar
        vanweelden
        Frequent Visitor
        3 years ago

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

         

        Testfile