Forum Discussion
Interactions: changing what gets filtered.
I'm looking for a way to alter what filters are applied through interactions. Coming from Tableau it was possible to select what happens when a user selects a piece of an individual visualizations, meaning the only specific filters were altered, and I'm looking for where these options are in Power BI.
In case I'm not getting my words across well enough, below are pictures. The top picture is the default view whereas the bottom picture is the filtered view due to the interaction. As you can see, the second visualization loses its "budget" bar because the graph with the selected interaction filters out the budget.
5 Replies
- lbendlin
Super User
Format...Edit interactions.
- Icey
Community Support
Hi Anonymous ,
Please refer to these document:
Change how visuals interact in a Power BI report;
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
lbendlin Thanks for the response but as described by Microsoft (https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions) that button only allows you to edit whether the interactions Filter, Highlight or Do Nothing.
Icey I appreciate the response but neither of those links deals with my question. The first link only shows how you can change between Filter, Highlight, and Do Nothing. The second link, from what I can tell, is fairly outdated as some of the options they mention aren't in the desktop version of Power BI and beyond that it doesn't deal with my question.
- lbendlin
Super User
You can also create measures that escape the filter context. Combined with the interaction options that will probably get you what you want. I would be wary though if your report users will understand and/or appreciate the UX.