Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous  - 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      HI Nathan

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

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