Forum Discussion

melanieruiz's avatar
melanieruiz
Regular Visitor
9 years ago
Solved

Slicer filter another slicer

Hi all. I just started using Power BI yesterday. I'm trying to build a report which contains a couple different slicers - Project and Employee. Currently, if I click on an Employee, it filters the rest of the visuals, including the Project slicer. However, when I click on a Project, it only filters the visuals but not the Employee slicer. I've edited the interactions of both slicers and they look like they should be filtering each other. Any ideas why this isn't working both ways? (I added the Employee slicer first, if that makes a difference).

 

 

Need Help

8 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    melanieruiz

    It sounds like that you're not setting a "both" cross filter direction.

     

     

     

    • melanieruiz's avatar
      melanieruiz
      Regular Visitor
      9 years ago

      Perfect, v-lvzhan-msft. That was it. I knew it had to be something simple.  Thanks!

      • jim_melichar's avatar
        jim_melichar
        Frequent Visitor
        9 years ago

        Where is this interaction handled in Power BI desktop? I was trying to solve this same problem, but I don't see where you were able to accomplish this.

         

        Thanks,

        Jim