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
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , GrandWizBiz 

Power Bi Desktop automatically generates us a hierarchy of dates (year, quarter, month, day). If you want to customize the hierarchy, you are right, you need to create your own columns with multiple dimensions, and then you can directly place them in our Matrix Row header or create a custom hierarchy.

For more information, you can refer to :
Power BI Date Hierarchy - Complete tutorial - EnjoySharePoint

And when you create a hierarchy, you need to note that the data of your previous level must be above the scope of your next level.

 

 

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

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