Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I would like to know if this is possible. I have a bar graph and a pie chart. When you select an item on the pie chart the relationship view in the bar graph changes to relfect the relationship to the selected data in the pie chart. However, the bar chart has many data points. All the unrelated data points are just made more transparent instead of being removed from the view.
Is there a way to not display information in a chart that is being filtered by related data in another chart? This would be great because then you wouldn't have to use the slider bar to scroll down to the remaining data that was relationally still relevent.
Thank you.
Hi @davidson929,
I don't know if you have already solved this but as you can see below if you do the following you will have what you need:
1 - Choose chart
2 - Format bar
3 - Edit Interactions
4 - On the other visuals in the page you will have options to change the interactivity in the charts - Filter; Highlight (default); None
Please check the print below, as you can see how image 3 after chosing the filter the bart chart only shows the value of the select values in the pie chart the others are removed.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @davidson929,
Have you resolved your problem? If you have, in order to help more people can find workwroud form here, please mark the helpful reply as answer. Thanks for understanding.
Best Regards,
Angelia
Hi @davidson929,
Based on my understanding, I create a example and test.
1. Create the bar chart and pie chart using same fields. When we select one filed one chart, it will highlighted in another table, while other are still exist invisual, they are not removed.
2. Create the bar chart and pie chart using fields come from different tables. But there is a relationship between. It display the same result when I select one value in chart.
I am still confusing your scenario, what's the mean of "All the unrelated data points are just made more transparent instead of being removed from the view" Could you please share more details or .pbix file for analysis.
Best Regards,
Angelia
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |