Forum Discussion
Customize time axis in a chart
Anonymous , You have to create a time table and create a sort column that will be lowest for 6 AM.
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
Hi Anonymous - Sorry this is not possible directly in your graph.
You need to do a bit of Transformation/Power Query.
Create a new Table with 4 rows:
Time CustomSort
6:00 AM 1
12:00 PM 2
6:00 PM 3
12:00 AM 4
Join your actual table time with this new table.
In your graph, use this new table time and CustomSort Column in tooltip and sort your graph based on this column.
Hope this help, Please let me know if you encounter any issues.
Cheers,
-Namish B
Hi Namish, thanks for your reply. I forgot to mention that my data is being captured every 30 secs and defining 4 categories will not display the whole 24 hr. I did define custom order for all 24 hr and it worked.