Forum Discussion
Adding week to date hierarchy
A PBI amateur here! I have a date field and when I use it as axis, Power BI automatically creates a hierarchy that has the Year, Quarter, Month and Day. I want to add the week number between Mont...
You could try turning off concatentation in your x-axis. To add week hierarchy you would want to create a separate date table using CALENDARAUTO and then add a column using WEEKNUM to that table. You would also want to add columns using YEAR, FORMAT([Date],"mmmm" and a quarter function probably using SWITCH. Then you could build a hierarchy manually using these columns. Relate that table to your other table in the obvious way.
I was able to fix this by creating custom columns for week number and formatting it in the way I want it to be. week_number actually included the year, which goes against our variable naming criteria and I was thrown off by that.
Thanks again for helping me out with this.