Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |