Mearns Learns

Table Mountain built with blocks

Turn off automatic date hierarchy in Power BI

When a date is included in a table, Power BI will automatically create a date hierarchy of Day, Month, Quarter, Year.

Turn off automatic date hierarchy in Power BI Turn off automatic date hierarchy in Power BI

Navigate to File - Options and Settings - Options

Turn off automatic date hierarchy in Power BI Turn off automatic date hierarchy in Power BI

Navigate to Current File - Data Load

Untick Auto Date/Time (under Time Intelligence)

Turn off automatic date hierarchy in Power BI Turn off automatic date hierarchy in Power BI

Date hierarchies in the existing file will be removed.

Date hierarchies will not be automatically created when new dates are added.

Turn off automatic date hierarchy in Power BI Turn off automatic date hierarchy in Power BI