Sort Y axis by day

[flemingg62]

Hi

I have a table with i have grouped many weeks data together by day of the week

The day is derived from the Dates 

Day Short = Format([TimeStart],"DDD")

How can I sort the table Monday to Friday?

[flemingg62]

Hi, Thanks I added a sort column but still no luck, I seem only to either show the Sort or the Day ccolumn.

[Anonymous · Accepted solution]

Hi @flemingg62 ,

First click the [Day Short] column -> click 'Sort by column' -> select the [DaySort] column.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[flemingg62]

Thks, I was trying to sort in the graph not the source table

[Shaurya]

Hi @flemingg62,

Create Day Short and DayofWeek as two columns in your Date Table. Sort Day Short by DayofWeek and then use it in the visuals.

Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI