Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter based on another visual result

Hi all,

 

I'm new with PowerBI and coming from MicroStrategy. In MicroStrategy I was using the concept of report sample filter and relationship filter quite a lot. Basically, the result of a visual was used as a filter for another visual. I've searched for a way to do this and on this forum but without success.

 

Lets say we have Visual A that shows a top 10 client number based on the amount spent over the last month.

Lets say we have Visual B that would show more information (and other facts) on the 10 clients from Visual A. 

 

How would you configure Visual B to take the client values from Visual A   as filter?

 

Thank you!

David

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

     If fields added to visual A and visual B are from the same table or related table, these two visuals are relative. You could apply filters to visual A via slicer or “Page/Report level filters” to get Top 10 records, that way, visual B will also be affected, showing corresponding details of the Top 10 clients.

     

    Best regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

     

     If fields added to visual A and visual B are from the same table or related table, these two visuals are relative. You could apply filters to visual A via slicer or “Page/Report level filters” to get Top 10 records, that way, visual B will also be affected, showing corresponding details of the Top 10 clients.

     

    Best regards,

    Yuliana Gu

    • Markzolotoy's avatar
      Markzolotoy
      Impactful Individual
      5 years ago

      Can you please elaborate on that? I have a clustered chart based on a table with 4 rows. Each row has a column in the chart. I have another table that details for each row/column. When I click on a column I want to filter records on the table on a column being clicked. Is your solution applicable for my need?

       

      Thanks