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...
User | Count |
---|---|
135 | |
83 | |
64 | |
57 | |
55 |
User | Count |
---|---|
212 | |
109 | |
88 | |
82 | |
76 |