Quick summary
To remove date hierarchy in Power BI, navigate to File > Options and Settings > Options, then uncheck Auto Date/Time under the Current File Data Load settings. This disables the automatic date hierarchy so your date fields display without the default Year, Quarter, Month, Day grouping.
Steps
- Open Power BI Desktop and select the report you want to modify.
- Navigate to the File tab in the top menu bar.
- Click Options and Settings from the File menu.
- Under Options and Settings, select Options.
- In the Options dialog, go to the Current File section and select Data Load.
- Scroll to the Time Intelligence section and uncheck the Auto Date/Time for new files checkbox.
- Click OK to confirm and apply the changes.
- The date hierarchy has been successfully removed from your Power BI report.
