Days out of order on Desktop but not PowerBI.com

[elliotdixon]

This is an odd one.

on my Power BI desktop program the days are out of order.

But then online they are in the correct order.

Good that they are in the correct order online but seems like a shakey solution. Anyone else come across this bug? I don't want it all to go wrong later on.

Cheers. ED.

[WillT · Accepted solution]

Hi Elliot. There are a few settings that determine the order that these would appear in. By default, categorical fields like this are set to appear alphabetically. You can override it by using the 'Sort By' feature: (https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column). The final override is in the chart itself - from the ... icon you can set it to sort by category or measure ascending/descending.

Either way - you should see the same between Service and Desktop! But worth checking that the settings above are all the same in both places... If not, then it's definitely a bug. Please click the 🙂 in the top left corner in Desktop and send us a mail. If you can attach the workbook it'll help us track down any problems!

thanks!

Will

[elliotdixon]

Awesome - I was able to use those instructions on Sort by Column to sort the day name by another column I had called DayofWeekNumber.  and it worked perfectly. Cheers for the help.