Date setting

[BI101]

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?

[Ritaf1983 · Accepted solution]

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):

https://radacad.com/all-in-one-script-to-create-calendar-table-or-date-dimension-using-dax-in-power-...

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