Forum Discussion
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,
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.
4 Replies
jhartranft60Advocate 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!
v-yuta-msftCommunity Support
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.