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 guys,
I am currently working on a overview to show the last 5 week of my sales per each customer
How can i sort the Week column in the table so i can get the logical order like 50 , 51, 52, 1, 2, 3?
in the following image you can see that the number 2 starts. this because i currently use the visual filter with filter type Relative Date Filtering to show the items in the last 5 weeks.
Any suggestions?
Many Thanks
Solved! Go to Solution.
Hi @Anonymous
you will have to add two more columns in your calendar table, one with the 'Year Week' and one with the Week Sequence and then sort Year Week by Week Sequence, you can check out the file I uploaded last week for this post:
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hi @Anonymous
you will have to add two more columns in your calendar table, one with the 'Year Week' and one with the Week Sequence and then sort Year Week by Week Sequence, you can check out the file I uploaded last week for this post:
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |