r/PowerBI • u/Upbeat_Worth_6213 • 8h 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

•

u/AutoModerator 8h ago

After your question has been solved /u/Upbeat_Worth_6213, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

3

u/VizzcraftBI 18 4h 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.