Forum Discussion
Using Week Number in X axis of Line Chart
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.
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
3 Replies
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
Yes, that works. Thanks very much.
Just remember to click to accept as a solution ;)
Regards
