Forum Discussion
100% Stacked Bar Chart Problem
N2siastD I think I was able to get pretty close to what you were going for. I'm not sure how you configured your bar chart to get the results you are seeing. See attached PBIX below signature. Used a simple conditional format for the bar colors on first page. Second page is closer to the original concept but can't change the bar colors. Third page I think is dead-on but is tricky to configure.
N2siastD Yes, use a clustered bar chart and utilize the small multiples feature.
Greg_Deckler I used the clustered bar chart and I used duplicated column that was used in small multiples as legend so I can change colors of columns but clustered column charts makes too many spaces between bars which doesn't look good. I tried using stacked bar chart but then I can not place data labels outside. Can I somehow remove the space between bars in the clustered chart?
N2siastD I think I was able to get pretty close to what you were going for. I'm not sure how you configured your bar chart to get the results you are seeing. See attached PBIX below signature. Used a simple conditional format for the bar colors on first page. Second page is closer to the original concept but can't change the bar colors. Third page I think is dead-on but is tricky to configure.
Greg_Deckler Now I got it right thanks to you! You're amazing! How do I become as good as you? Lots of time and practice right?
N2siastD I've been on these forums for 9 years answering questions and learning all along the way so yes, time and practice I suppose! A lot of my learning I share on my YouTube channels and I'm definitely going to do a video on this one as I learned quite a few things putting this together.