Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Week in date hierarchy

Hi there.


I have data points each containing date of occurrence. I display it on line chart mostly. I want enable user to drilldown by week aggregation. Just like they can do Year/Quater/Month/Day with automatically created date hierarchy from date field. I tried adding week column with WEEKNUM, then delete day from the hierarchy and add WEEKNUM column, but then when drilling down the line chart is being largely widened.


My question is how to add week aggregation to date hierarchy?



To be more specific:

With automatically created date hierarchy from date field [Date] 'mm/dd/yyyy HH:MM:SS AM/PM' I can drill down from Year > Quarter > Month > Day and the axis is continous and nicely narrowed together (not having to scroll):



But when I created calendar table with DAX, deleted Day from hierarchy, put Fiscal Week and added beneath Day of Month down in hierarchy I CAN drilldown Year > Quarter > Month > Fiscal Week > Day of month but when getting to week and month x axis starts to be categorical and user has to scroll to see the whole spectrum:



I want to avoid changing x axis to categorical and make user to scroll the chart to see whole spectrum


Community Support
Community Support

@WolskiDo you mean you want to add Week to hierarchy and then let users use Drill Down function in the visual to drill to Year/Quarter/Month/Week/Day levels to see data in different granularity? It sounds an interesting challenge and need some time to investigate.


I'm curious too... has anyone found a way to solve this?

Sorry, I haven't found a solution to this...

Exactly, thats my goal.

Helpful resources

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors