Using Week Number in X axis of Line Chart

[android1]

Hi,

In below line chart I'd like to show Week Number along the bottom axis instead of month. I am using column Service Date which when I change to Date Hierarchy, I only get the option of Year.

[jbocachica · Accepted solution]

Hi, you must create your own hierarchy, just add a column with WEEKNUM(YourTable[YourDateField],1) and use that column in your chart.

If you want to see, just download the PBIX

https://mliworkers.blob.core.windows.net/jboca/Chart%20with%20Week.pbix

Regards

[android1]

Yes, that works. Thanks very much.

[jbocachica]

Just remember to click to accept as a solution 😉

Regards