cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to group fields in a table

Hello,

 

In a table, imagine that I have let's say 40 fields and that I would like to group some of those.

 

 

For example, suppose that I would like to create a Location Group into Table A and move the following fields into the Location Group.

 

 

Table A

var1

var2

...

Location

     Geographic Region

     Location

     Province

     City

      Country

      and so on.

Var6

var7

....

 So How do we create a group into a table and push the field into it?

Regards,

1 ACCEPTED SOLUTION

@Anonymous ,

 

Group is totally different from hierarchy in power bi. Grouping is to aggregate your data into chunks (or groups) based on values found in the underlying data while building hierarchy is to give you drill down option so that you can clearly see the sub-level values.

 

If you need to group several fields in your table, you may refer to doc below:

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
jhartranft60
Advocate IV
Advocate IV

@Anonymous 

If I understand what you want correctly, you should be able to just drap the fields you want in that hierarchy on top of one another.  Take a look at this post and let us know if this is what you're looking to do: https://community.powerbi.com/t5/Desktop/How-to-create-Hierarchy/td-p/479913

 

Hope it helps!

Anonymous
Not applicable

What's the difference between creating a new group and creating a new hierarchy?

 

@Anonymous ,

 

Group is totally different from hierarchy in power bi. Grouping is to aggregate your data into chunks (or groups) based on values found in the underlying data while building hierarchy is to give you drill down option so that you can clearly see the sub-level values.

 

If you need to group several fields in your table, you may refer to doc below:

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Good morning,

 

I apologize for not being enough clear about what I was looking for.

I found a paper published by Chris Webb about the Nested Display Folders in Power BI.

 

That is exactly what I was looking for.

Thank for your help.

 

Regards,

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.