Forum Discussion
Solved
dynamic bar chart sorting from pie chart
I have pie chart which shows data by industry and a bar graph which shows data by occupation. When i click one of the industry, the bar graphs also updates dynamically but sorting remains the same an...
sshekar7 - If you want to do this you need to change the interaction from the pie chart to the bar chart.
When your pie chart is selected go to the "Format" page in the top menu and select "Edit Interactions" then you will see some new icons in the top of your bar chart with "Highlight" selected change this to "Filter" instead.
No the way that the cross highlighting works is that it shows the values in the other tables in the same order to make it easier to show what the related values are. If you want to filter the data you can use slicers, this will filter the data and reoorder everything.
Hope this helps,
Kasper