Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello all,
for a bar chart I have year / month / cw / date levels. when I use YEAR_CW like
2020 52, 2020 53, 2021 01, 2021 02 and so on...
the sorting works. but when I use the fork arrows i see to many years like "2021 2021 01 2020 53 JAN".
So it is possible to sort the calender week without using the year like 52, 53, 01, 02? (also the same for month)
Thanks.
Solved! Go to Solution.
@Pikachu-Power , I doubt that is possible. It will not allow you to create a sort column.
Check I tried in this video https://www.youtube.com/watch?v=KK1zu4MBb-c
@Pikachu-Power , I do not think it is possible. Once you try to create such sort column, you will get error
@Pikachu-Power , I doubt that is possible. It will not allow you to create a sort column.
Check I tried in this video https://www.youtube.com/watch?v=KK1zu4MBb-c
Do you mean possible or not possible? In your case you can sort YEAR MONTH SORT but for me it doesnt work somehow.
Sorry i clicked accidentally accept the solution.
@Pikachu-Power , I do not think it is possible. Once you try to create such sort column, you will get error
User | Count |
---|---|
83 | |
77 | |
71 | |
70 | |
54 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |