Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Chillytouch
Frequent Visitor

Why is this date showing as a hierarchy?

Hi,

 

I am currently making a new report and I am recycling some data elements from a report that a previous developer worked on. Looking at this custom table "WeekCalendar", the "fiscal_first_day_of_period" (and similar columns) show as basic columns. That is how I want it to be. However when I created the same exact table in a new report, it is showing those same fields as date hierarchys which I do not want. Is there any way to change that? I only know how to change it when you put the field into a visual, but that doesn't change how it shows in the table. Any thoughts as to why this happened/how to change it?

 

Thank you! 

 

pbiIssue.png

1 ACCEPTED SOLUTION
OzkanDhont
Resolver II
Resolver II

Hi @Chillytouch !

 

The hierarchy has been auto generated?

You can turn it off in Options and Settings > Data Load > Time Intelligence > Uncheck Auto date/time.

 

Hope it helped!

 

Kind regards,

OD

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@Chillytouch File | Options and settings | Options and turn off Auto Time Intelligence for GOBAL and Current File.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
OzkanDhont
Resolver II
Resolver II

Hi @Chillytouch !

 

The hierarchy has been auto generated?

You can turn it off in Options and Settings > Data Load > Time Intelligence > Uncheck Auto date/time.

 

Hope it helped!

 

Kind regards,

OD

That worked, thanks a ton!!!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors