Forum Discussion
Clustered Bar Chart - Selection
I have a Clustered Bar Charts in a dashboard with one-many relations. Selecting a bar highlights the relevant bars (data) on the other. My client want to only display the highlighted bar and totally remove the others and readjust the bars accordingly. Is that possible to achieve in PowerBI dashboard?
Thanks, Krishna
Hi Anonymous,
Do you mean filtering out the second chart based on selections in the first chart? Is so, below solution helps
"Use Edit Interactions option from Format tab that appears when you click on a visual. In the Edit Interactions change the property for the second visual to FIlter"
This will filter out the second graph while you make selections in the first graph. But as you click on the other graph, the other data bars starts appearing.
Get Detailed information about Edit Interactions here
On the other hand, if you mean that when you select on a visual, then the second visual should get filtered and that the other data should not return back on clicking on the graph, then that's not directly available. But you can achieve it indirectly (which might require the user's contribution as well)
Set the First Graph to Filter out the second graph in Edit Interactions
When you click the first graph data bar, your second graph will get filtered based on the "Edit Interactions". Now right-click on all the bars in the second graph that you need and click "Include". Now your graph will be fully filtered and that only those bars which you included will stay. Know more about this here
For your reference, find the screenshot below
4 Replies
Hi Anonymous,
Do you mean filtering out the second chart based on selections in the first chart? Is so, below solution helps
"Use Edit Interactions option from Format tab that appears when you click on a visual. In the Edit Interactions change the property for the second visual to FIlter"
This will filter out the second graph while you make selections in the first graph. But as you click on the other graph, the other data bars starts appearing.
Get Detailed information about Edit Interactions here
On the other hand, if you mean that when you select on a visual, then the second visual should get filtered and that the other data should not return back on clicking on the graph, then that's not directly available. But you can achieve it indirectly (which might require the user's contribution as well)
Set the First Graph to Filter out the second graph in Edit Interactions
When you click the first graph data bar, your second graph will get filtered based on the "Edit Interactions". Now right-click on all the bars in the second graph that you need and click "Include". Now your graph will be fully filtered and that only those bars which you included will stay. Know more about this here
For your reference, find the screenshot below
Hi KrishnaBose ,
I'm afraid currentlt there's no such option in bar chart. You can submit your idea here: https://ideas.powerbi.com.
Regards,
Jimmy Tao
