Posts tagged #Hierarchies

5 Reasons to Hide Fields from Report View in Power BI

Let's discuss five reasons why you'd want to consider hiding columns from the report view in Power BI. All of these suggestions are centered around curating the Fields list during report development for both yourself, and any other potential business users or analysts who might want leverage your model for reports in the Power BI service. Tune in to learn more!

Video by: Reid Havens

Creating Date (Calendar) Hierarchy Columns in Power Query

Video by: Reid Havens

Part two of two of my videos on creating a Power Query Calendar Table. In this video we’ll see how to create the necessary date columns needed for dependent and independent hierarchies.

RELATED CONTENT 🔗

Part 1: Creating a Dynamic Range Calendar Table in Power Query

Posted on October 5, 2021 and filed under Power BI, Intermediate, Power Query.

Implementing Different Date Table Hierarchy Types in Power BI

Video by: Reid Havens

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.

Posted on August 31, 2021 and filed under Beginner, Data Modeling.