Forum Discussion
Comparing the same data after applying two different sets of slicers
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 ...
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