Forum Discussion

GrandWizBiz's avatar
GrandWizBiz
New Member
3 years ago

Date Hierarchy

I am struggling to understand the concept of heirarchies and how their interact with other columns, I've watched and read alot of content but clearly am clearly missing something obvious.    I have...
Need Help
GrandWizBiz's avatar
GrandWizBiz
New Member
3 years ago

Hello!

 

Thanks for your reply. It seems like my date columns havent auto generated - which is odd as my legacy file I made a few years ago using the same underlying dataset did. 

 

I have time intelligence enabled:

 

 

But all my date columns do not have the calander icon aligns to them:

 

My end outcome is a I want to be able to build visuals that show the number of sales I have aligned to day/week/month/quarter/year and a mixture of those such as month-year. 

 

I'll continue reading through your documents as well though to see if there is something I have missed. 

 

 

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , GrandWizBiz 

    Thanks for your quick response!

    For "Why there is no date hierarchy", you can refer to this document:
    Why there is no date hierarchy - Microsoft Power BI Community

     

    And for your need , i recommend you to create  a custom hierarchy in your side.

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly