Comparing the same data after applying two different sets of slicers

[Anonymous]

I have two tables with the same structure and data. My end goal is to divide a report into two sides and then compare the different margin results on one line graph. I would like to filter each side of the report with its own set of filters. I have gotten this far and have two separate views of margin. Margin 1 and Margin 2.

The margin for contract group I'm tracking starts in separate months so my hope is to plot these all on a line graph using month 0-24. For this I created a third table called Relative Months and have that going from 0-24. This table is now joined to the two others. 

• How can I get Margin 1 and Margin 2 into the same table or graph? 

I have done a lot of digging and tried a few things but have not been able to crack this one. Would appreciate any help!

[mahoneypat]

If you have a shared Relative Months table going to two separate Margin tables, what issue/error are you seeing.  If you use the shared table/column for the axis, and have two separate measures (one for each Margin) in the line chart, it should work and you should be able to use slicers from columns from each table that would not affect the other margin.  What are you seeing?

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat