Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
PBInonpro
Helper III
Helper III

What is the use of hierarchy?

I am not understanding why we need to use hierarchy when we can drop associated fields in anyways. If someone can explain the concept of hierarchy vs not using hierarchy? 

 

(bonus question: is there an equivalent forum for SharePoint or any SharePoint experts here?)

1 ACCEPTED SOLUTION
Shaurya
Memorable Member
Memorable Member

Hi @PBInonpro,

 

Hierarchies are useful for exploring data and creating drill down visuals. There a lot of things that can be made easier if you use hierarchies in Power BI. I have this link that might give you more detailed information:

 

https://radacad.com/what-a-power-bi-hierarchy-is-and-how-to-use-it#:~:text=A%20hierarchy%20in%20Powe...

 

Did I answer your question? Mark this post as a solution if I did!

View solution in original post

2 REPLIES 2
DataInsights
Super User
Super User

@PBInonpro,

 

A hierarchy is a way of grouping fields, making it easier to add multiple fields to a visual. It has no impact on the data. Here's an article on the topic:

 

https://radacad.com/what-a-power-bi-hierarchy-is-and-how-to-use-it 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Shaurya
Memorable Member
Memorable Member

Hi @PBInonpro,

 

Hierarchies are useful for exploring data and creating drill down visuals. There a lot of things that can be made easier if you use hierarchies in Power BI. I have this link that might give you more detailed information:

 

https://radacad.com/what-a-power-bi-hierarchy-is-and-how-to-use-it#:~:text=A%20hierarchy%20in%20Powe...

 

Did I answer your question? Mark this post as a solution if I did!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.