Customize order on x graph

[eduzzino5]

Hi there,

I'm trying to do a graph were I see the monthly sales gruped by day of the week - but for no reason the values are randomly sorted.

I can sort them in aphabetic order...but in this case I would need to set a custom order otherwise I get all the days in random order and my graph doesn't make sense (see below)

Is there a fuction that allows me to do that?

Thanks,

Eddie

[v-jiascu-msft · Accepted solution]

Hi @eduzzino5,

You can still use the names of the days in the visuals. But the order will make sense because it's ordered by the numbers.

Best Regards!

Dale

[v-jiascu-msft · Accepted solution]

Hi @eduzzino5,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[Greg_Deckler]

You can create a column for this, I would use WEEKDAY:

https://msdn.microsoft.com/en-us/library/ee634550.aspx

Then you could set your "Sort By" for your "Day of the week" to be this new column.

[eduzzino5]

Thanks a million for the reply 🙂

I thought about that, but I want to show my customers the name of the days, not the numbers...

[v-jiascu-msft · Accepted solution]

Hi @eduzzino5,

You can still use the names of the days in the visuals. But the order will make sense because it's ordered by the numbers.

Best Regards!

Dale