Forum Discussion
100% Stacked Bar Chart Problem
Hello is it possible to make 3 charts from this 100% stacked bar chart by making white empty dynamically calculated columns in between used as separators?
So it would look something like this?
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.
5 Replies
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.
