Forum Discussion
Problem with displaying date formatting
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.
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.
1 Reply
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.