Forum Discussion
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
Thanks again,
I have to compare "offset" periods, but not allways the same ones
- 2022 vs 2019
- 2022 vs 2021
- 2021 vs 2015 ...
That's the reason why i have to use 2 parametres (current one and refference one)
But unfortunately i'm no able to do it ... for the moment ! may be my mind is too Excel-focused to solve it.
🙂
Super UserIf 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
Thanks a lot for your help, you compleatly answer to my request.
Have a nice day/evening