Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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 @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
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)?
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |