Problem with displaying date formatting

[Syndicate_Admin]

Hello.

I have the following problem and that is that the database that model is SQL and the date which I want to model is with the correct format as seen in the image:

However, when it comes to graphing on the desktop, it does not appear with the calendar icon as it should:

Because of this I can not use the hierarchy of dates to graph as I want and it is a problem for me, I already made sure that everywhere I appear in date and nothing.

If you have the solution to this problem I would appreciate it since I have been trying to achieve it for a week.

Best regards.

[v-angzheng-msft · Accepted solution]

Hi, @Syndicate_Admin 

Based on the information you provided, make sure that the Time Intelligence setting is checked and that the data storage mode is Import mode.

when you have a connection between tables (using date format) what happens is that the main date (table in wich you have the one in one-to-many relationship) is the one that get the hierarchy "treatament"

In Power BI Desktop, you select File > Options and settings > Options, and then select either the Global or Current File page. On either page, the option exists in the Time intelligence section.

When the option is enabled, Power BI Desktop creates a hidden auto date/time table for each date column, providing all of the following conditions are true:

• The table storage mode is Import
• The column data type is date or date/time
• The column isn't the "many" side of a model relationship

refer:

Apply auto date/time in Power BI Desktop

Date Hierarchy falls to appear when joining on the date

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.