Forum Discussion

Arendp's avatar
Arendp
Helper III
6 years ago
Solved

Date indicator gone

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?

 

Need Help

5 Replies

  • FrankAT's avatar
    FrankAT
    Community Champion
    6 years ago

    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

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Arendp
      Helper III
      6 years ago

      Data types are for both fields the same: Date

      So I don't think this is the problem.