Forum Discussion
Sort time interval in chronological order
Hi Anonymous ,
I used some of your values (not all) and tried to simulate your issue. I think I came to a solution.
From this slicer here....
...I was able to sort them and ended up with this:
I first created a new column in power query where I parsed all the values before the delimeter "-" of the interval column, ending up with the dates in text format. I then changed the type of the new column to date. Finally, I used the "sort by" function to order the intervals by the new column as seen in the link of the previous answer.
Hope this helps!
/Tom
Most Valuable ProfessionalHi Anonymous ,
I used some of your values (not all) and tried to simulate your issue. I think I came to a solution.
From this slicer here....
...I was able to sort them and ended up with this:
I first created a new column in power query where I parsed all the values before the delimeter "-" of the interval column, ending up with the dates in text format. I then changed the type of the new column to date. Finally, I used the "sort by" function to order the intervals by the new column as seen in the link of the previous answer.
Hope this helps!
/Tom