Does the "Gap analysis" permit more than 2 groups to compare?

[Jackeline]

I would like to compare 3 groups using the gap analysis but the PowerBI just permit two groups and others only using the filter. Any idea how to solve this? Thanks!

[v-yuezhe-msft]

@Jackeline,

The Gap Analysis visualization is a visual used to compare the difference aka gap between two groups across multiple categories. When you have more than two groups, you would need to use filter as mentioned below.


In your scenario, I would recommend you create column/measure to calculate the gap value between different groups, then use built-in bar/column chart to display the gap values.



Regards,
Lydia