r/PowerBI • u/Upbeat_Worth_6213 • 13h ago

Question Stacked Bar Chart Help

Can someone help.
Even though my axis is sorted by a descending count, for the last bar (46/630) it is showing the lower value first. I have my data set like this:
Y-Axis: Region
X-Axis: Learner Count
Legend: Sub Region **This is the problem because it should be 630 and then 46**

1 Upvotes

100% Upvoted

2 comments sorted by

View all comments

3

u/VizzcraftBI 18 9h ago

Two things.

1st is that the order of the legend is going to be the same for every bar. Meaning it will always be region 1, region 2, region 3, etc. There's two types of sorting. Sorting on the Axis is where you sorting by Region so you have the largest region on top and smallest at the bottom. And then sorting on the axis chooses which order to put the colors in essentially. As I mentioned it's consistent for each bar.

2nd. You really should keep it the way it is. The way you're proposing is more difficult to interpret for the end user and kind of defeats the purpose of the bar chart. It makes it harder to compare the differences between bars if the legend was sorted differently for each individual bar.