Show X axis with week number and month (But no Concatenate labels in formatting)

[NickProp28]

Hi folks, 

I would like to have week number and month show together in x axis. But I didnt find the off toggle of Concatenate labels in the formatting. No idea is I miss out something in the line graph. Kindly advice.

Expected outcome: 

Please have a look on my pbix: https://ufile.io/66mkuot2

Appreciate any help you can provide to me. 

[v-xulin-mstf · Accepted solution]

Hi @NickProp28,

After switching off concatenate labels as:

Drill down:

Here is the output:

If you want to learn more, please refer: https://community.powerbi.com/t5/Community-Blog/How-to-change-the-granularity-of-date-in-X-axis-of-l...

Best Regards

Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@NickProp28 , You need to week and Month(Month should have sort order) , Put both on them on the X-axis and sort on them (using three dots), Switch off concatenate labels

[NickProp28]

Dear @amitchandak ,

Thanks for the response. 

I have put month and week on the axis, but the (three dot) doesnt have the sort. 

Please have a look on my pbix: https://ufile.io/66mkuot2