Forum Discussion
Date hierarchy
While using desktop, my model has date hierarchies, which i need. Auto date / time is checked on my settings. However, when i publish my model to the service and use via data hub to build reports against, the hierarchies have disappeared. Is there a way to stop that happening?
Thank you
Hi Anonymous
I'm not sure if that is possible. Would you not consider using a Date table instead and creating relationships from the Date Table to your Fact table. You can then create date hierarchies however you wish from year to days.
This opens a whole array of time inetlligence measure possibilities. It will also reduce the size of your dataset drastically, as when you switch off auto time/date, it will reduce the size of the model.
Here are some articles that will help you with Model design
https://learn.microsoft.com/en-us/power-bi/guidance/star-schemahttps://learn.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time
Joe
2 Replies
Hi Anonymous
I'm not sure if that is possible. Would you not consider using a Date table instead and creating relationships from the Date Table to your Fact table. You can then create date hierarchies however you wish from year to days.
This opens a whole array of time inetlligence measure possibilities. It will also reduce the size of your dataset drastically, as when you switch off auto time/date, it will reduce the size of the model.
Here are some articles that will help you with Model design
https://learn.microsoft.com/en-us/power-bi/guidance/star-schemahttps://learn.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time
Joe