Forum Discussion
Format > Group vs Merge
What is the difference between Group and Merge. Under Format, for visualizations.
2 Replies
- TheoCCommunity Champion
Hi bmcminn
The Group you have highlighted allows you to "group" multiple visualisations together. Simply select two visualisations and then click Group and you'll see these are grouped as 1 (i.e. you can move them around as a single visual group, etc).
However, there is also the "Group" function that allows you to group certain data points / records within a single column as one group, as well. Imagine you have a column called Countries. In that you have Australia, New Zealand, USA and Canada. If you right-click on the column in the Data pane on the right, you can select New Group. From here, you can create a "New Group" called North America and add USA and Canada to that group and, similarly, do the same with Oceania by adding Australia and New Zealand.
"Merge," on the other hand, is a function that lets you combine multiple visualisations together into a single visualisation. For example, you can merge a chart and a table into a single visualisation to display both visualisations in one place. When you merge visualisations, Power BI creates a new visualisation that displays the combined data from the source visualisations.
Hope this helps!
Theo 🙂
- BaboonXRegular Visitor
Hi!
With the 'merge' feature for groups, you can merge multiple groups into one single group.
E.g. if you select two groups and use the group > merge command, it creates a new group with all items from the two selected groups. Where if you use the conventional group > group command, it creates a new group where the other two groups are then inside as sub-groups.
You can also select a single group and some additional items, then the merge command will just include the additional items in the already selected group.
If you select multiple groups that also have sub-groups in them, the highest level groups are merged into one and all sub-groups are merged into the new unified group as its sub-groups.
Hope that helps!
Alex