Keep hours in chronological order

[Syndicate_Admin]

Nice day.

I have problems with a graph and a table, I would like to analyze the results of the weight of some bottles that is done every 30min, but when working ewn power BI the hours of order from lowest to highest.

Example: Registration starts on day 1 at 16:30 and ends on day 2 at 21:30

En la grafica de igual manera inicia desde las 00:00 sin importar el orden del dia 1 y dia 2In the graph in the same way starts from 00:00 regardless of the agenda of day 1 and day 2

En la tabla de power BI se ordena de menor a mayor ya horaIn the power BI table it is sorted from lowest to highest and hourLa tabla de datos en excel con las horas desde que iniiciaThe data table in excel with the hours since it starts

[v-yiruan-msft]

Hi @Anonymous ,

If I understand correctly, you would like to make a custom sort for the time range(from day 1 16:30 to day2 21:30). These time spans two days and there are duplicates in the time section, so I'm afraid I don't have a better way to implement custom sorting. Unless you refer to the following blog, create a dimension table with two columns: one for all the datetime columns from the fact table and the sort you want as in the following table. 

Sort a Column with a Custom Order in Power BI - RADACAD

Subsequently, follow the steps later in the blog to complete the custom sorting.

Best Regards

[amitchandak]

@Syndicate_Admin , I Hope the datatype is time, not text. If text then create a number to sort  and mark that as a sort column 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[Syndicate_Admin]

It is indeed a variable in time format in both excel and power BI.

I reviewed the video but it doesn't help in my concern.

Thank you for your reply.