Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I am trying to sort some time intervals in a slicer. They each represent a week, yet they are in a very strange order. I think PBI interprets them as text instead of time interval, so each number is sorted like characters.
I want to sort them in chronological order. I think based on the first date should be good enough. May I ask how I can do that? Thank you!
Solved! Go to Solution.
Hi @stoneluo ,
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
https://www.instagram.com/tackytechtom
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @stoneluo ,
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
https://www.instagram.com/tackytechtom
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi you can't sort your column with another column.
- First column (in your slicer) contain start and end of week
- Second column contain start of week and you sort on it
May help you
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column