Forum Discussion
Filtering with 100% Stacked Bar Chart
Hello,
Need some urgent assistance on this one, please!
I have 2 charts,
1. A pie chart showing color distribution which looks like below,
2. A 100% Stacked Bar Chart with the same distribution based on different segments.
What I want:
I want the bar chart to totally filter itself based on the colour selection I make in the pie chart.
Example- When I click on the Green slice in the Pie chart, in the 2nd Bar chart, I intend to see only green bars with their respective values ( 34.04%,48.81%,73.91% etc..) and the rest of the colours to be filtered out of the chart.
I know there's an option "Edit Interactions" which enables Highlighting but that's not what I want. Instead, I want the visual to filter itself so that the selected colour takes up the entire bar chart and shows the correct values based on their respective segments.
I tried adding a colour slicer but the problem is when I select a particular colour, all the values get distributed to 100% because I believe the denominator is affected,
FYI - These charts are currently based on columns and not measures.
I would really love your help with this, I've been trying to crack this for a long time!🙏
- Anonymous4 years ago
Hi Anonymous ,
It's a bit difficult if you are using 100% stacked bars chart. Because it is always guaranteed that the final result of each bar is 100% (which would lose a lot of information).
We can make slight changes to the stacked bar chart so that it becomes a 100% stacked bar chart, and with cross-filtering, we can successfully achieve our goal.
The PBIX file is attached for reference:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
2 Replies
- AnonymousNot applicable
Hi Anonymous ,
It's a bit difficult if you are using 100% stacked bars chart. Because it is always guaranteed that the final result of each bar is 100% (which would lose a lot of information).
We can make slight changes to the stacked bar chart so that it becomes a 100% stacked bar chart, and with cross-filtering, we can successfully achieve our goal.
The PBIX file is attached for reference:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
- ChenwuZhu_GmailResolver I
Hi Anonymous ,
Sorry, I don't understand what you want because you don't want highlighting. Can you draw it out?
Best regards.