Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Thejeswar
Resident Rockstar
Resident Rockstar

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

include-exclude.png

 

 

 

 

View solution in original post

4 REPLIES 4
Thejeswar
Resident Rockstar
Resident Rockstar

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

include-exclude.png

 

 

 

 

Anonymous
Not applicable

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)?

 

Anonymous
Not applicable

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

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.