Forum Discussion
android1
Post Patron
Post PatronUsing 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
jbocachica
Resolver II
Resolver IIHi, 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
android1Yes, that works. Thanks very much.
- jbocachica
Just remember to click to accept as a solution ;)
Regards