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 re...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    melanieruiz

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

     

     

     

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

    • Dog's avatar
      Dog
      Icon for Responsive Resident rankResponsive Resident
      9 years ago

      Hi Jim. 

       

      if your data is available through Power BI then you should be able to access the relationships by clicking on the bottom of the 3 icons in the top left. 

       

       

      however, if your Power BI uses AS as a data source then it cannot be accessed in this way. 

       

      Dog. 

       

      • jim_melichar's avatar
        jim_melichar
        Frequent Visitor
        9 years ago

        Yes, we're using AS as the data source. I'm bumping into lots of issues related to that. Thank you and I appreciate the note.