Filter based on another visual result

[Anonymous]

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

[v-yulgu-msft · Accepted solution]

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]

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