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.

     

     

     

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
    Responsive 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.

      • Dog's avatar
        Dog
        Responsive Resident
        9 years ago

        Hi Jim, 

         

        No problem. Are you currently managing the model through visual studio or similar. 

        if that's the case, you should be able to amend the relationships through that. 

         

        Dog