Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Is there a way to automatically filter what is displayed on one chart based on a selection made in another chart?
I want to create a bar chart that is filtered to a group based on what is selected on a map. So, for example, you select a point on a map that is in the state of Texas - the bar chart would only show data points that have Texas listed as the state.
Solved! Go to Solution.
Hi @Domenick,
Assuming I understood your question correctly, yes it is possible to filter a visual based on the selection made in another visual.
By default, Power BI visuals are interactive and whenever you select any data point in a visual, the relevant data in all other related visuals does get highlighted.
Nothing is selected
Bikes is selected in Total Orders and relevant data is highlighted in Subcategory Treemap
To enable cross-filtering -
Voila! That's how you enable cross-filtering and use Edit Interactions. For more info, refer to the following docs.
Hi @Domenick,
Assuming I understood your question correctly, yes it is possible to filter a visual based on the selection made in another visual.
By default, Power BI visuals are interactive and whenever you select any data point in a visual, the relevant data in all other related visuals does get highlighted.
Nothing is selected
Bikes is selected in Total Orders and relevant data is highlighted in Subcategory Treemap
To enable cross-filtering -
Voila! That's how you enable cross-filtering and use Edit Interactions. For more info, refer to the following docs.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |