Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi friends!
I am trying to just sort the hours of the day under each day of the week (ie: 7am, 8am, 9am, 10am, 11am, 12pm, 1pm, etc.) This is a Matrix visualization.
For some reason I can't figure out how to do it? The days are set up as DATE fields and the hours as TIME fields. You would think this would be sorted by default??
I think even if they were in order that it would look odd as you'd be missing times. Maybe try something like this, join it to your dataset, and sort by the new time column?
https://community.powerbi.com/t5/Desktop/how-to-build-a-calendar-table-with-date-and-time/m-p/242658...
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 63 | |
| 55 | |
| 42 | |
| 41 | |
| 23 |
| User | Count |
|---|---|
| 171 | |
| 136 | |
| 119 | |
| 79 | |
| 54 |