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
Follow these steps in order to 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
Step-2: Select Technology & Furniture to using Ctrl + Click.
Power BI Group
Step-3: Click on Group button, you can change Group members name then click to OK.
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
Step-5: See the final Output with group.
Power Bi Group
How to Modify Group?
Right click on Group, select Edit groups
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.
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:
How to create Custom Theme in Power BI