Use filters for specific colums in matrix

If you want to compare random fields e.g.:-

- 2022 vs 2019

- 2022 vs 2021

- 2021 vs 2015 ...

then you cant do it will 2 slicers on the same dataset,

because when you slice by 2022 the data will only be for 2022.

The solution is to use 2 copies of the data each with a slicer.
With no relationship with each other.

Then have 3 measures:-

YearA = SUM(SalesfileA[value])

YearB = SUM(SalesfileB[value])

Difference = YearA - YearB

You can then have 2 slicer

SalesfileA[Year]  and SalesfileB[Year]

You can imporve the solution using 2 Calendar tables, but the principle is the same.

Please click the thumbs up and Accept As Solution