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,
pls I have problem with X-axis order even if I used "Sort axis > week of year > sort ascending", it didn't solve my problem. How could I resolve it? Help me pls
Solved! Go to Solution.
If you're not using a calendar table. You should do that.
Next you go and create a integer version of the yearweek and use Power bi Sort by function.
here is an example but with months in stead. I hope you get the general idea.
Hi, they are sorted alphabetically - you can try formatting your weeknumber as "0#" so that when you have week 6, you get 06, instead of 6 - this would translate to 2022-06 and it will be sorted properly. That's the easiest thing you can do, having a calendar table is always a good approach, as already suggested above.
If you're not using a calendar table. You should do that.
Next you go and create a integer version of the yearweek and use Power bi Sort by function.
here is an example but with months in stead. I hope you get the general idea.
Hi,
I am not sure without seeing your dataset, but I assume you can try to sort week of year column by weekenddate column in the same table.
If you do not have a weekenddate column in the same table, try to create this in Power Query Editor or by DAX formula (Calculated Column), and then sort week of year column by weekenddate column.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |