Forum Discussion

K2_Gail's avatar
K2_Gail
Regular Visitor
9 years ago

Date Hierarchy for multiple datetime columns - inconsistent behavior

I have data coming from SQL. The table in SQL has multiple columns of type "datetime". I imported the data (it is not Direct Query). I have created a Date table, and defined relationships. I believe...
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

K2_Gail

 

I’m not sure what your table relationships like, but I think you can try to duplicate the date column which does not have date hierarchy in visual, and use this duplicated date column instead of the original date column in X Axis to see if it works.

 

Best Regards,

Herbert

  • K2_Gail's avatar
    K2_Gail
    Regular Visitor
    9 years ago

    So, I'm still not sure I understand WHY this works, but I removed ALL relationships between date/time columns in my data table and my Calendar/Date table. Then, all my date/time columns display proper Date Hierarchies.

     

    I'm still pretty new to all this, so I'm not sure why I need to REMOVE the relationships, but that seems to have given me the results I wanted, at least.

     

    • v-haibl-msft's avatar
      v-haibl-msft
      Microsoft Employee
      9 years ago

      K2_Gail

       

      What is the relationship between your data table and Calendar (Date) table, one to many or one to one?

       

      Best Regards,

      Herbert

      • K2_Gail's avatar
        K2_Gail
        Regular Visitor
        9 years ago

        Well, initially, I was setting it up one-to-many. And when that was not working so well, I tried one-to-one.

        Then, I removed them entirely, and things worked the way I wanted. :)