how to use matrix to compare 2 quarters in the page with 2 quarter slicers contains

[selpaqm]

Hi,

I have 2 columns one of them q1 and the other q2 (duplicated columns). Have lots of graphs on this page. q1 and q2 slicers are (quarters like 3-22, 6-22, 9-22 etc) effecting graphs (using edit interactions). however, I want to add a matrix to compare the figures based on selected values q1 and q2.

my row data is as below.

ID	Sales	Q1	Q2
aaaa	10K	03-2022	03-2022
aaaa	20K	06-2022	06-2022
aaaa	5K	09-2022	09-2022
bbbb	20K	03-2022	03-2022
bbbb	10K	06-2022	06-2022
bbbb	10K	09-2022	09-2022
cccc	5K	03-2022	03-2022
cccc	15K	06-2022	06-2022
cccc	25K	09-2022	09-2022

so wanna see a table as below

	(selected quarter on q1 slicer) ie 09-2022	(selected quarter on q2slicer) ie 03-2022
ID	sales	sales
aaa	5K	10K
bbb	10K	20K
cccc	25K	5K

so I have already duplicated tables and try to get numbers from 2 tables and created connections etc. but not succeeded.

[CNENFRNL · Accepted solution]

[CNENFRNL · Accepted solution]

[selpaqm]

@CNENFRNL  Thanks for the solution. is there any chance to add a progressing measure to see the difference between 2 selected seasons like aaaaa = -5 bbbbb=-10 ccccc=20

[CNENFRNL · Accepted solution]

Simple enough, based on the previous solution, a third measure

Diff = [Sales Q1] - [Sales Q2]

[selpaqm]

@CNENFRNL  thanks for it, working really too much on a thing sometimes makes me blind to any other things. thanks again for your helps