Below you'll see where I've got times imported for a chart, only they're all out of whack. I've tried sorting them in the file itself, in PowerQuery, etc. Tried a bunch of different things and I am absolutely stumped. Anyone know a good way to get these to actually sort by time? Something I did put the 7:00am at the beginning, but not the other AM's - not sure what that was.
Many thanks!
@TristanC you are sharing the link of the report that is published into your Power BI tenant. Nobody will able to access it without credentials and on top of that you shouldn't be doing that. You are putting your company info in jeopardy. Just a suggestion.
For sharing purposes, create a dummy pbix file and share it using one drive/google drive.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@TristanC weird, this time column is not sorted by any other column, right? And the type of this column is what?
Also, does this column have a date element to it? What value do you see for this column in PQ? I think this column contains date/time value not only time value and that is causing this.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@TristanC check how this visual is sorted, click on the top right corner, 3 dots and see the sort column and the sort order.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@TristanC the column you are using on x-axis, you should sort it by a time column which is not a text and then it should work, or you can have time column on the x-axis and change the format of this column the way you want to display and use that on the x-axis.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I think I've done what it is you're suggesting. The column itself mis-orders itself, though? In Data View we can see here:
That's after I "sort ascending" - so I'm confused as to why it's going from 7:00am to 12:00pm? I've tried sorting by descending, making another column numbering each starting time and sorting from that, nothing seems to work. The Excel file from which I'm working is sorted correctly (by Start Time). It's a puzzler, for sure. Super un-intuitive, however it's supposed to work.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
