Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |