Date Hierarchy

[Anonymous]

Hi Experts

I have loaded data into power Bi and all the date coloum expect for one have a out date hiearcrhy created by Power BI. How do i add a date Hierarchy to this one other column.

See image

[Anonymous]

@Anonymous  - The data type needs to be Date. Then the auto-generated date table will be created. You may need to format the column before it will work.

Cheers!

Nathan

[Anonymous]

HI Nathan

the data tyoe it date...just looked on the modelling tab

[Anonymous · Accepted solution]

@Anonymous  - Check in Power Query, to make sure it is Date type there. If not, change it and I think it should update automatically.