Forum Discussion

breben's avatar
breben
Microsoft Employee
2 years ago
Solved

Filter on a filter?

My dataset includes a field with various values, including product name, and another field with customer name.

Each customer name would have multiple product names that could apply to it. 

 

CustomerA - Acme App, Beta App, Charlie App, Delta App

CustomerB - Beta App, Delta App

Customer C - Acme App, Delta App

 

Creating visual for this is straight-forward.  My issue is:

I want to have a visual that filters on customers that have Acme App but also shows any other product names that are related to that customer.  A standard/advanced filter can reflect which companies have Acme App, but then I have difficulty getting the other product names to list, since the visual is already filtered to only include the Acme App value.  I've tried this with visual filters and page filters and I always have the issue that once I apply the filter to focus on customers that have Acme App I can't pull in the other product names the customers have since they have been filtered out.  Ideally I would want a filter that decides which customers have Acme App but also still me to list other products the customer owns.  Hopefully this is clear and someone can provide some input. thanks!

 

 

 

  • breben's avatar
    breben
    2 years ago

    resolved, please try again, thanks!

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi breben ,

    Below is my sample table:

    I create a slicer using App field:

    The final output is shown in the following figure:

    If the test sample data I used does not meet your requirements, could you please share the pbix file, thank you!

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Hi,

    Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User

      On double clicking the file, i get a message saying "Unable to open document.  The file sensitivity label could not be verified".

      • breben's avatar
        breben
        Microsoft Employee

        resolved, please try again, thanks!