X - AXIS chart design

[Anonymous]

hi 

how to get this desing in X axis

[v-jingzhang]

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.

[Tahreem24]

@Anonymous Take Bar chart and add Week number and Year columns in X-Axis.  Then click on expand button on the chart.

[goncalogeraldes]

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

[Anonymous]

hey 

thanks for the comment.

yes but it gives me this out come :

[goncalogeraldes · Accepted solution]

@Anonymous if you haven't tried @Tahreem24 solution have you tried creating a Year/week hierarchy and using it in the x axis?

[Anonymous]

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