Is there a way to filter a column chart based on a selection in another visual?

[Domenick]

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.

[Bipin-Lala · Accepted 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 - 

• Select the map visual, go to the "Format" pane, and navigate to the "Edit interactions" section.

• Once the visual is selected, all other visuals will now show 3 types of interaction icons

• The options are Filter, Highlight, and No Filter
• Select the first option for Cross-Filtering
• Now when you select Bikes in Total Orders, notice the Subcategory Treemap gets filtered instead of highlighting data points

Voila! That's how you enable cross-filtering and use Edit Interactions. For more info, refer to the following docs.