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 am wondering how can I rearrange y-axis the weeks in order? For example, week 1, week 2, week 3, week 4... As you can see from the screenshot, the order of the week is a little messed up. I am using line chart if that helps 🙂
Thank you!
Solved! Go to Solution.
Hello @Anonymous
You need to add a numeric column to your table that has the week field on it. 1, 2, 10, 22, 37, etc. Then you set the sort order on your week field to use the WeekNum column. You can see a solution for a similar problem here.
https://community.powerbi.com/t5/Desktop/Issue-with-Table-Not-Sorting-by-Month-Day/td-p/773279
Hi, the best way to do this is like jdbuchanan71 said. You can also solve this from other perspective. You can transform your data with two values for the int in order to order correctly. Like this:
Week 01
Week 02
...
Week 10
Week 11
Saving the data as text like this will order in correct way.
Hope this helps too.
Happy to help!
Hello @Anonymous
You need to add a numeric column to your table that has the week field on it. 1, 2, 10, 22, 37, etc. Then you set the sort order on your week field to use the WeekNum column. You can see a solution for a similar problem here.
https://community.powerbi.com/t5/Desktop/Issue-with-Table-Not-Sorting-by-Month-Day/td-p/773279
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 |