Easy Tech TutsHow to Remove Date Hierarchy in Power BI (Stop Auto Grouping) Easily 2026
By Impran M N
Power BI automatically breaks date fields into a year-quarter-month-day hierarchy, which is handy sometimes but frustrating when you just want a chart to show exact daily dates. This guide covers why that auto-grouping happens and the steps to turn it off. It's meant for analysts who need granular date control rather than Power BI's default drill-down structure.
01Understand the default date hierarchy
Power BI automatically treats date fields as hierarchies with year, quarter, month, and day levels unless you tell it otherwise.
02Know why you'd want to remove it
Removing the hierarchy is useful when you want a visual to plot exact dates on a continuous axis instead of grouped time periods.
03Follow the step-by-step guide to stop auto grouping
Turn off the auto date/time setting in Power BI's options, or drag the date field's date value (not the hierarchy) directly into your visual instead.
04Review practical use cases for businesses
Disabling the hierarchy is especially useful for detailed trend analysis, like daily transaction tracking, where grouping by month would hide meaningful spikes or drops.
Frequently asked questions
Where do I turn off Power BI's automatic date hierarchy?
Go to File > Options and Settings > Options, then under Data Load, disable the Auto Date/Time setting for new files or the current file.
Can I remove the hierarchy for just one visual instead of the whole report?
Yes, in the visual's field well, click the dropdown next to the date field and choose the date value instead of the hierarchy to bypass grouping for that specific chart.
Will disabling auto date/time affect existing reports?
It can, since visuals already using the hierarchy may need to be rebuilt to reference the date field directly once the setting is turned off.
Does removing the date hierarchy affect performance?
Turning off auto date/time can actually improve model performance and reduce file size, since Power BI no longer generates hidden hierarchy tables behind the scenes.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
