The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Proud to be a Super User! Regards, Bipin Lala | Business Intelligence Developer | |
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.
Proud to be a Super User! Regards, Bipin Lala | Business Intelligence Developer | |
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
107 | |
96 | |
53 | |
47 | |
47 |