Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I want to show data on weekly basis for entire year. im not able to create sort column for Weeknumber.
Thanks in advance.
Hi @Vinod_G_245
when creating your weeknumber column please use the following formula in power query.
"KW" & Text.PadStart(Number.ToText([WeekNumOfYear]),2,"0")
then it should sort correctly.
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Hi Mike,
Thanks for the solution. Im facing below errors in type Conversion. Please find attachments
Week of year is in text format in calendar table.
Please on top tell Power BI in the visual to sort ascending by the week and not by the value
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |