Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
The extract of my current dates table:
So i have managed to create a date table with the help of other users and everything was fine untill i tried to sort one of my tables based on the week value. i tried to sort by week both ascending descending and im not getting the correct sorting. The only waz i can get it to work is when i add the week number to my table and the issue with this approach is on the following screenshot. Power bi is putting the last weeks of 2019 after the first weeks of 2020.
I would appreciate if anyone has an idea on how to tackle this issue.
Thanks in advance
Solved! Go to Solution.
Perhaps Sequential?
https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231#M116
Perhaps Sequential?
https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231#M116
Hello there @Greg_Deckler , thanks a lot for your prompt reply.
I have tried to following column based on your link but it seems that its not working;
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
40 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |