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.
Hi Anonymous,
What do the data of "week_number" and "day_of_month" look like? Can you share the file? Maybe only the "Date" table is needed.
Best Regards,
Dale