Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 a table, it includes multiple date columns like "Date Created" and "Date" "Date Closed" and a few others. Each for formated like this: xx/xx/xxxx xx:xx:xx
I want to be to have a hierarchy that allows me to do Day (Name)/Week/Month(Name)/Quarter/Year
And then a few combinations such as Month-Year & Quarter-Year.
My column looks like this:
and is formatted to this:
I've tried building out a full date table from scratch, I can make the individual columns like this:
but when turned into a hierarchy I cannot form a relationship with my 'primary' table.
Anyone able to help?
Documentation on the auto-generated date hierarchy
Auto date/time in Power BI Desktop - Power BI | Microsoft Learn
Hello, maybe this article will be useful to you for a general understanding of this topic: https://insightsready.com/blog/post/date-hierarchies-in-power-bi-integration-extension-by-insights-r...
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.
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
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
84 | |
84 | |
73 | |
49 |
User | Count |
---|---|
143 | |
132 | |
110 | |
65 | |
55 |