Problem with displaying date formatting

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.