Forum Discussion
Post PatronDate format gone on relations connect
why Date format gone on relations connect
firstly i thought is happens because of date/time formats, and always spliting date/time to date and time, but now this trick stops working.
why this happens and how to fix?
Hi Digger ,
The flag with a calendar style indicates the date hierarchy.
With no relationship, both two date columns have a date hierarchy.
After the one-to-many relationship is established, the daily hierarchy of the main table will disappear.
This is because Power BI has a feature called auto date/time.
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
More details you can refer to
Auto date/time in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Digger , when you join a table with date of date table, You might see this behavior. But Check in column tools , it should still be date, you might not get date hierarchy.
You can add new date column
date_start1 =[Date_start]
Hi Digger ,
The flag with a calendar style indicates the date hierarchy.
With no relationship, both two date columns have a date hierarchy.
After the one-to-many relationship is established, the daily hierarchy of the main table will disappear.
This is because Power BI has a feature called auto date/time.
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
More details you can refer to
Auto date/time in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
