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.
@Anonymous if you haven't tried @Tahreem24 solution have you tried creating a Year/week hierarchy and using it in the x axis?
Hi @Anonymous
Please perform the following four steps:
1. Select Clustered Column Chart, put Year and Week columns into Axis field (Week at a lower level), and a value in Values field.
2. Click Expand All Down icon on the chart.
3. Go to Format pane and turn off Concatenate labels under X axis.
4. Click ... on the chart and select Sort axis > Sort ascending and Sort by Year Week.
Currently your chart is sorted by Value descendingly.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@Anonymous Take Bar chart and add Week number and Year columns in X-Axis. Then click on expand button on the chart.
Hello there ! Have you tried to use the arrowd in the upper right corner to "Expand all down one level in the hierarchy"?
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️
@Anonymous
hey
thanks for the comment.
yes but it gives me this out come :
@Anonymous if you haven't tried @Tahreem24 solution have you tried creating a Year/week hierarchy and using it in the x axis?
thanks u all guys!!
yes the issue was the sorting 😕 i was not aware that we need to also sort by the dates for it
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |