Forum Discussion
Date setting
Hi,
I have entries in power bi that are a date - the data type is selected as date/time and i've refereshed the dashboard and everything but i'm still not able to get the calendar pop up next to the date column like i am some of the other ones.
the other ones automatically show up and i can break the date down into month/year/etc. any idea what i can do?
Hi BI101
The best practice for working with the date hierarchies is to create a date table with the needed columns and there to create a wanted hierarchy.Please refer to the linked tutorial about creating a date table (including the needed script):
and the video about how to use hierarchies
https://www.youtube.com/watch?v=ChpMo6TUy5U
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
Hi BI101
The best practice for working with the date hierarchies is to create a date table with the needed columns and there to create a wanted hierarchy.Please refer to the linked tutorial about creating a date table (including the needed script):
and the video about how to use hierarchies
https://www.youtube.com/watch?v=ChpMo6TUy5U
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly