Ravindra BagaleCourses & study guides Track your progress

Guides

How to Turn Off Auto Date/Time in Power BI Desktop

By , Power BI & Data Analytics trainer LinkedIn Published: Last updated:

Auto date/time quietly builds hidden date hierarchies for date columns; for serious models you should turn it off (current file and usually global) and use one marked Date table related to your facts instead.

Chala mitrano! Auto date/time feels helpful on day one and confusing on day ten. Why? Hidden date tables fight your real Date dimension. How? We see the symptom, switch the Options checkbox, and point visuals at a proper Date table — FreshBasket (fictional) style. Let’s go step by step.

Quick answer

Vertical fix:

  1. Notice extra automatic date hierarchies under every date column.
  2. File → Options and settings → Options.
  3. Current File → Data Load → uncheck Auto date/time.
  4. Optional: Global → Data Load → uncheck for new files.
  5. Create/mark a real Date table and relate it to facts.
  6. Rebuild visuals using Date[Year], Date[Month], etc.
Options → Data Load → Auto date/time OFF
+ one marked Date table

Why turn it off (what goes wrong)

Imagine three date columns on Sales: OrderDate, DeliveryDate, PromoDate.

  1. Auto date/time can build a hidden calendar for each one.
  2. Your Year slicer then has more than one “Year” story.
  3. Time intelligence measures get confused.

Tiny sales by day:

OrderDate City Amount
2026-01-05 Mumbai 100
2026-01-12 Mumbai 40
2026-01-20 Nashik 80
  1. With a proper Date table, January YTD for Mumbai is 140.
  2. With fighting auto calendars, students see blanks or double years on the axis.
  3. Interviews expect: “I disable Auto date/time and use one marked Date table.”
Auto date problem Hidden date hierarchies clutter Auto date/timehidden hierarchy per date column clutter

Auto date/time creates hidden date hierarchies per date column — handy for demos, messy for serious models.

What do I need before this guide?

Before and after (look at the tables first)

Before turn off Auto date/time; all years total 190.

Before

After Date table Date table Year 2025; total 140.

After

Turn Auto date/time off and use a real Date table. Then Year = 2025 on Date[Year] cleanly leaves 140.

What Auto date/time does

  1. Power BI can generate hidden date tables/hierarchies per date column.
  2. Beginners get Year / Quarter / Month drill-downs quickly.
  3. Multiple hidden calendars appear — messy for DAX time intelligence.

How to turn it off

Turn off auto date Options Data Load uncheck Options Data Load Uncheck off

Turn off: File → Options → Data Load → uncheck Auto date/time (current file and/or global), then use a real Date table.

Current file

  1. File → Options and settings → Options.
  2. Current File → Data Load.
  3. Uncheck Auto date/time.
  4. OK; follow any prompts to apply.

Global default

  1. Same Options dialog → Global → Data Load.
  2. Uncheck Auto date/time so new .pbix files start clean.

Replace with a real Date table

Date table vs auto Prefer marked Date table Auto hierarchies Date tablemarked + related prefer

Prefer one marked Date table related to facts; disable Auto date/time so DAX time intelligence stays predictable.

  1. Build or load a Date dimension (continuous dates covering your facts).
  2. Table tools → Mark as date table (unique date column).
  3. Create relationships from fact date keys to Date[Date].
  4. Use Date fields on axes and slicers.
  5. Retire visuals that pointed only at auto hierarchies.

Shop analogy: Auto date/time is three cheap calendars taped to the wall. A marked Date table is one shop calendar everyone trusts.

Mistakes and calm fixes

Symptom Likely cause Fix
Hierarchies still appear Only global changed / file not refreshed Uncheck Current File; rebuild
Time intel wrong No marked Date table Mark date table; fix relationships
Duplicate years on axis Mixing auto + Date fields Use Date table only
Broken old visuals They used auto hierarchy Recreate with Date[Month] etc.

Ghabru naka 😅 — turning the setting off is one checkbox; rebuilding visuals is the real homework.

Ravindra Bagale's Tip

Many students leave Auto date/time on, then write CALCULATE time patterns that mysteriously double-count. Disable it early — like putting on a seatbelt before the highway. Remember this!

Practice task

  1. Open Options and screenshot Auto date/time before/after (current file).
  2. Mark a Date table in a sample model.
  3. Replace one chart axis with Date[Year] / Date[Month].
  4. Note one sentence you would say in an interview about this setting.

Learn it properly

Course lessons:

Related guides: CALCULATE / filter context · Panes

Got it? Auto date/time OFF + one marked Date table. That keeps time intelligence honest. Next: row context vs filter context. Let's continue.

Frequently asked questions

What is Auto date/time?

A Power BI setting that silently builds hidden date tables/hierarchies for date columns so beginners get Year/Quarter/Month drill-downs.

Why turn it off?

Serious models want one Date table, clear relationships and predictable time intelligence — Auto date/time adds hidden clutter.

Will existing auto hierarchies disappear?

After you disable and clean the model, rely on your Date table fields; recreate visuals that pointed at auto hierarchies.

Mark as date table?

Yes — select your Date table → Table tools → Mark as date table with a unique date column.

Global vs current file?

Current file affects this .pbix; Global affects new files. Set both if you always want control.

Course lesson?

Auto date/time hierarchy vs a custom Date table in the hierarchies chapter.