Forum Discussion
Date Hierarchy for multiple datetime columns - inconsistent behavior
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
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.
What is the relationship between your data table and Calendar (Date) table, one to many or one to one?
Best Regards,
Herbert
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. :)
I just tried with two simple tables, one Calendar table and one Sales table. They have one to many relationship with Date key as below.
The Date Hierarchy works well in following column chart. Is there any difference between us?
Best Regards,
Herbert