Date indicator gone

[Arendp]

I have a table that is related to a  date table:

ShipDate <--> Date

Strangely enough, the ShipDate doesn't have the date indicator.

When I remove the relationship between date table and table which holds ShipDate, then ShipDate has again a date indicator.

How is this possible?

[FrankAT]

Hi,

the calendar icon indicates that Power BI Desktop uses a hidden date hierarchie for that column.

1. Disable in File > Options and settings > Options > Current File > Date Load > Time Intelligence the control button "Auto date/time. The calendar icon disappears.

2. Mark the calendar table as date table.

 Regards FrankAT

[Arendp]

Thanks also for your reply.

I had already done this...

So unfortunately this also doesn't solve it...

[v-chuncz-msft · Accepted solution]

@Arendp 

You may check the post below.

https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/m-p/438804#M202476

[Anonymous]

Select column/Field, then Goto Modeling and check for Data Type: it must be Date/Time or Date.

If it's Text you dont get Hierarchy.

[Arendp]

Data types are for both fields the same: Date

So I don't think this is the problem.