cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pikachu-Power
Post Prodigy
Post Prodigy

Create Date Hierachy

hi all,

i have a simple date column EI. I want to create a Date Hierarchy like

DH.PNG

With Date Hierachy / Year / Quarter / Month / Day and want to use this column in a measure.

Should be simple or? But coundnt find a way to do this.

1 ACCEPTED SOLUTION

Nothing works. At the date column i dont see this white date kalender picture which i want to expand. when i create hierchy no year/month/quarter/day is automatically added and i cant use it in measures.  

 

The hierachy is always a new column that i dont want.

 

Solved was a mistake. cant take it back.

View solution in original post

6 REPLIES 6
Tahreem24
Super User
Super User

@Pikachu-Power ,

Make sure that you DateColumn has Date format so automatically it will create hierarchy. Else Create three different Column for Year, Month, and Date then add into hierarchy. 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

Nothing works. At the date column i dont see this white date kalender picture which i want to expand. when i create hierchy no year/month/quarter/day is automatically added and i cant use it in measures.  

 

The hierachy is always a new column that i dont want.

 

Solved was a mistake. cant take it back.

Hierachies i cant use in measures right? How do i create this white date table which i can expand to the hierachie?

Hi,

 

2 solutions were given to you :

Solution 1 :

You create the columns and then add them to your date to create manually a hierachy. That means that first using DAX functions you'll add columns using YEAR({YourDate]), MONTH([YourDate])... Once you have created all required columns, go back to the Report View and in the Fiels panel, use the Right click or drag and drop to create hierarchies.

More details here : https://community.powerbi.com/t5/Desktop/How-to-create-Hierarchy/td-p/479913

 

But my recommendation, likewise other helpers, is to create a date table.

In the post of @amitchandak you have many links to know more about the instructions to create one.

 

Let us know which solution you choose

AilleryO
Solution Sage
Solution Sage

Hi,

 

Normally date hierarchy are automatically made by Power BI, except if your set it differently in the option of the software.

 

If your table is marked as a Date Table, then you will not have hierarchy.

 

Anyway the best option for you might be to create a Date Table and linked it to your fact table. The you'll have all the hierarchy you need.

 

Another option is to create your columns using YEAR(), MONTH() functions.

But still my recommendation would be to create a date table. If you want to know more about it, many discussions have been made :

https://community.powerbi.com/t5/forums/searchpage/tab/message?filter=location&q=table%20date&noSyno...

Hope this help

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!