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.
Hello,
I think the image explains it's self. How can I sort, so week 53 jan 2021(3 days) will move all the way to the left as first week of 2021.
Week 53 dec 2020 is should still remain (4 days).
Using calculated column below in my Date table.
Solved! Go to Solution.
Hi @PVO1 ,
You can't sort based on your original data because 53 weeks are in different years. You need to concatenate with the year field to sort.
Please create 2 new columns:
year week = YEAR('Table'[Date])*100+'Table'[week]
sort = YEAR('Table'[Date])*100+WEEKNUM('Table'[Date],2)
Then sort year week column by sort column.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot. This is what I already tried.
Unfortunatly this will show the year values twice. If I remove year from the visual sorting will again will be incorrect. In that case I need another 2 columns that will correct the months. But, then I would have the same problem (week 53 2020 & jan 2020). So I guess what I'm looking for is not possible.
Nevertheless I will accept this as solution and I made my own format. As shown in the picture.
Hi @PVO1 ,
You can't sort based on your original data because 53 weeks are in different years. You need to concatenate with the year field to sort.
Please create 2 new columns:
year week = YEAR('Table'[Date])*100+'Table'[week]
sort = YEAR('Table'[Date])*100+WEEKNUM('Table'[Date],2)
Then sort year week column by sort column.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot. This is what I already tried.
Unfortunatly this will show the year values twice. If I remove year from the visual sorting will again will be incorrect. In that case I need another 2 columns that will correct the months. But, then I would have the same problem (week 53 2020 & jan 2020). So I guess what I'm looking for is not possible.
Nevertheless I will accept this as solution and I made my own format. As shown in the picture.
@PVO1 , You have to create a sort column like
Sort Week = if[Week.Num] =53 && month(Datum[Datum) =1, 0, [Week.Num])
Week.Num 1 =[Week.Num]
Now Week.Num 1 on Sort Week and use that is visual
Refer, why this way : https://www.youtube.com/watch?v=KK1zu4MBb-c
Thanks a lot for your reply! Unfortunatly I think I missed something.
I created both the [Sort Week] and [Week.Num 1] columns. I (obviously) can't still sort any columns because of multiple values.
So if I use [Week.Num 1] in my visual I have the same result as before.
If I use [Sort Week] in my visuals it displays week 0 instead of 53.
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |