Create a graph comparing values of two sliced subgroups

[AFS]

Hello.

Sorry for the bad title. Let me explain the problem with an example.

I have two different pages with data on an Excel file. Let's call them P1 and P2:

I want to create a graph that compares the values of a group from P1 and a group from P2 with the help of slicers. Here's what I got.

At the top there's a slicer to select a Group (I, II or III) from both P1 and P2 each. In the image, group II is selected for P1 and group I is selected for P2.

In the middle there are two graphs from P1 and P2 respectively, showing the values of each name (A, B and C) from the group selected in each splicer. Both of these are correct, and I want to combine them in a single graph.

At the bottom you can see my attempt at the combined graph (selected). The values from P1 are showed correctly but the values from P2 are wrong, showing the total instead of each value.

This is probably a simple problem but I can't seem to figure it out. I'm trying to find a solution that doesn't require editing the Excel file, but if that's not possible then it doesn't matter.

Thanks in advance.

[Greg_Deckler · Accepted solution]

Create a Names table like:

Name

A

B

C

Make the obvious relationships to P1 and P2 tables. Use Names[Name] as your Axis.

[AFS]

Worked like a charm.

Cheers!