Forum Discussion
Finer control over visuals interaction?
Hello,
I am trying to have three visuals interact as if they were drilled-down from to the other, for lack of better explanation.
Donut chart1 is filtering donut chart2 when one item is selected.
Donut chart2 is filtering donut chart3 when an item is selected in chart2.
I have used the "Edit interactions" accordingly however it does no seems to be possible to achieve the result I am seeking.
Chart 1 will indeed filter chart 2 correctly. but I when I selected one category in chart 2, chart 1 filter is reset, chart 2 is showing all values like it was prior to making a selection in chart 1. Same behavior between chart 3 and chart 2.
An image is more explicit, here are the pages at the various stage of interaction:
Initial page display, all sites in left side. All categories and subcategories on the right-side:
A site is selected; accordingly, only the category manufactured at this site are displayed in the second chart, really neat!
Here is where the dream collapse... making a selection in the second chart to view only the related subcategory actually reload all category as the site is "unselected". The related subcategory are displayed but since the site chart is reset, the numbers are not good, they are global values, not the site's value. The interaction between chart2 and chart1 is set to "No interaction"; same thing for chart3 towards chart1 (and chart2 for that matter):
Can I reproduce the equivalent of a drill-down with a single chart but spread visually on separare visuals?
Regards
Anonymous if you want to select data point from multiple visuals, you have to hold ctrl key when making 2nd selection. Read more on it here Multi-select data elements in visuals, or multiple visuals, in Power BI Desktop - Power BI | Microsoft Docs
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
2 Replies
- parry2kSuper User
Anonymous if you want to select data point from multiple visuals, you have to hold ctrl key when making 2nd selection. Read more on it here Multi-select data elements in visuals, or multiple visuals, in Power BI Desktop - Power BI | Microsoft Docs
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- AnonymousNot applicable