cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
KrishnaBose Frequent Visitor
Frequent Visitor

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?

Capture.PNG

 

 

Thanks, Krishna

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Thejeswar Senior Member
Senior Member

Re: Clustered Bar Chart - Selection

Hi @KrishnaBose,

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

include-exclude.png

 

 

 

 

4 REPLIES 4
KrishnaBose Frequent Visitor
Frequent Visitor

Clustered Bar Chart - Selection

I have a dashboard with a one-many relationship of data, where a selection of the parent highlights all relevant child data. 

My client now wants to show only the highligted data and remove rest when a selection is made, Is this possible to acheive?

Krishna

 

jenelrosales Regular Visitor
Regular Visitor

Re: Clustered Bar Chart - Selection

When you say "display the highlighted bar and totally remove the others and readjust the bars accordingly", which bars do you want to remove? The bars on the other chart (child)?

 

Community Support Team
Community Support Team

Re: Clustered Bar Chart - Selection

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

Thejeswar Senior Member
Senior Member

Re: Clustered Bar Chart - Selection

Hi @KrishnaBose,

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

include-exclude.png