Time in text Data type

[Chandramouli_BI]

I table has a column which is time diff of 2 hrs in the format (0:00-1:59, 2:00-3:59, 4:00-5:59,6:00-7:59,8:00-9:59,10:00-11:59,12:00-13:59,14:00-15:59,16:00-17:59,18:00-19:59,20:00-21:59,22:00-23:59). The data type is text column. I have created a line chart but I am not able to sort this axis in time order as the dat type is text. I want the same labels(0:00-1:59, 2:00-3:59, 4:00-5:59,6:00-7:59,8:00-9:59,10:00-11:59,12:00-13:59,14:00-15:59,16:00-17:59,18:00-19:59,20:00-21:59,22:00-23:59) dont want to change the names. How to sort them in this order?

[Chandramouli_BI · Accepted solution]

Hi @Idrissshatila I did the same but I am getting blank data. I mean there is no data in the column. Can you pls help me with that

[Idrissshatila]

Hello @Chandramouli_BI ,

you need to add an ordering column to set each record and then use the order by column functionality to order the main text column by this ordering column.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Chandramouli_BI · Accepted solution]

Hi @Idrissshatila I did the same but I am getting blank data. I mean there is no data in the column. Can you pls help me with that

[Igna · Accepted solution]

Hello, 

Ordering your data should not modify them. If you have blank values after doing it, take a look at your data before filtering because there must be a problem with them. 

Maybe check this link to be sure to ordering them correctly : https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

Igna