Home » Power BI » Create Group in Power BI

Create Group in Power BI

Power Bi Group

As the name suggested, Power BI Group feature is used to merge or combine two or more visuals values together.

It’s helps you while you want to see two or more visuals values together and want to analyze that data with other visual values.



 Download Sample data : SuperStoreUS-2015.xlxs

Without Group how visual look like:

  • Here we have three separate Product Categories: Technology, Furniture & Office Supplies
Pie Chart

Pie Chart



Create a Group

Now create a Group to merge Technology & Furniture values together.

Step-1: Right click on Product Category Field and click on New group

New Group

New Group



Step-2: Select Technology & Furniture to using Ctrl + Click.

Power Bi Group

Power Bi Group



Step-3: Click on Group button, you can change Group members name then click to OK.

Power Bi Group

Power Bi Group



Step-4: Group created successfully, now select pie chart and drag  new Group field to Legend and Sales field to Values.

Power Bi Group

Power Bi Group

Final Output with group

Power Bi Group

Power Bi Group



How to Modify Group?

Right click on Group, select Edit groups

Group



Ungroup the previous group members & make new group members

Now let’s make the new Group members and Ungroup the previous Group members

  • Select Group members and click on Ungroup button
  • Then follow the same process, Using Ctrl+Click, select Technology & Office supplies and click to Group button

Power Bi Group

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.



Recommended Post:

Power Bi Performance Analyzer

How to create Custom Theme in Power Bi

Custom Tooltips in Power Bi

Enable Syncs Slicers in Power Bi

Power Bi Interviews Q & A

Leave a Reply