Sort stacked bar chart by Y axis (date ascending)

[JNelson]

Hello,

I have a stacked bar chart with dates (linked to a Calendar Table) as the Y Axis. I cannot get it to sort by date ascending. I want it to start at the current date then show the next 7 days. I don't have the option to Sort By as per other visuals. It's very frustrating and won't be user friendly for them to have to read from bottom up. I also don't want to mess my calendar table up as it's working perfectly for the rest of the file. 

Thanks in advance!

[Ritaf1983 · Accepted solution]

Hi @JNelson 
You can download Akvelon bar chart from the marketplace place it has a desired sort option :

From an effective data visualization standpoint, this chart should be a column graph rather than a bar graph.

This is because most of our brains are accustomed to perceiving the timeline as a horizontal axis.

Bar graphs are typically used for ranking, where there is a list of entities without a logical connection that are ranked by size.

Column graphs, on the other hand, are used to represent a series of trends over time or another logical axis.

I recommend changing the orientation of the graph to better represent the data.

Anyway the pbix with a sorted graph that you asked is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[JNelson]

Thank you, I will try this.

I've been requested to show it in a bar chart to notify the operations which days have too much allocated to them.

Thanks for your help

[Ritaf1983]

Yep, users often know what they want, but that doesn't necessarily mean they also know what they need.

In such cases, I usually present both options and ask an informative question in 95% of cases.

From this, the user can usually grasp which graph format is easier for them to read.

Unfortunately, we are all too accustomed to inaccurate and ineffective visualizations.

Good luck in any case!

[v-tianyich-msft]

Hi @JNelson ,

There are try to sort by column well, specifically you can follow the following steps: click the date field, in the column tool to find sort by column, and then select your value.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[JNelson]

Thanks for your response but it doesn't really help. It's already sorting by date. Other visuals are sorting the same date field perfectly, it's just the stacked bar that's not working.