Forum Discussion
Time in text Data type
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?
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
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-desktop
Igna
3 Replies
Hello Anonymous ,
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 💡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
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-desktop
Igna
