Forum Discussion
Sort Y axis by day
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
How can I sort the table Monday to Friday?
Hi flemingg62 ,
First click the [Day Short] column -> click 'Sort by column' -> select the [DaySort] column.
Best Regards,
Gao
Community Support TeamIf 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
4 Replies
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 BIHi, Thanks I added a sort column but still no luck, I seem only to either show the Sort or the Day ccolumn.
Hi flemingg62 ,
First click the [Day Short] column -> click 'Sort by column' -> select the [DaySort] column.
Best Regards,
Gao
Community Support TeamIf 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
Thks, I was trying to sort in the graph not the source table
