Implementing Different Date Table Hierarchy Types in Power BI

Learn about two primary Hierarchy types you can implement on a Date Table in Power BI. I consider it a best practice to include dependent and independent date hierarchies, which can impact how users want to navigate the hierarchy controls in visuals.

BECOME A CHANNEL MEMBER 🎉

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:34 - Content Intro

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #datetable #hierarchy #hierarchies

[antonycatella]

Really interesting alternative to a dependent hierarchy. Great idea Reid

[angelangelov]

Thanks for the great advise! So to the point, clear and nicely presented! Super helpful!

[datazoe]

That is just awesome! I've been using dependent hierarchies all the time. I will give it a try on the independent ones for sure!
As always, amazing content!

[ishanagrawal]

Great! But I'm unable to sort qtr, month in independent hierarchy. Also, dates are un continued due to missing dates records in the source file. How to fill the gaps in dates?

[wayneedmondson]

Very interesting! Thanks for sharing this information. Thumbs up!!

[texmexdragon]

Hi Reid - Is there a way to accomplish this for the week & year? I have month & year done, but week & year seems tougher to get into a date format

[jadwiga]

Wow, I had no idea, this will be very useful!

[AussieFirebug]

Can we get the PBIX for this file, please?

[pabeader]

Mind: BLOWN! Independent hierarchies, who knew?

[tinaflemons]

The Independent Hierarchy does not appear to work correctly if the Calendar was created with M language

[alisahib]

Sir, please create a video on it "How to get Facebook page, LinkedIn Profile real time data into Power BI and how to analyze it?" please sir it's my humble request to you.
God bless you
Thanks and Regards
Muhammad Ali