cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Route217 Member
Member

Date Hierarchy

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

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
natelpeterson New Contributor
New Contributor

Re: Date Hierarchy

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

 

3 REPLIES 3
natelpeterson New Contributor
New Contributor

Re: Date Hierarchy

@Route217  - 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

Route217 Member
Member

Re: Date Hierarchy

HI Nathan

 

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

natelpeterson New Contributor
New Contributor

Re: Date Hierarchy

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