Order of Chart

[Anonymous]

Hello - 

I have a chart that shows hours (y axis) by days (x axis). I am using a stacked bar chart, where the hours are split by "before", "after", and "during". 

Right now, the chart organizes the information by - after, before, during. I would prefer the order to be before, during, after. 

What's the easiest way to do this? 

Thanks,

M

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Locate to Query Editor mode, add a conditional column.

In report view mode, choose the field that should be added to legend, change its sort by setting from default to "Order" column.

Result.

Best regards,

Yuliana Gu

[davehus]

You could do a conditional If statement in the query window to add a numerical value. Before 1, During 2, After 3. Then sort it by the number. Either that or use the Switch function to do something similar.

D