Forum Discussion
Compare values in matrix visual with different filters
Hi Anonymous,
Based on my test with your shared pbix file, you may need to take two more steps to make it work.
1. Remove all relationships among the three tables.
2. Use "Year Scenario" column from Date1, and "Year Scenario-2" column from Date2 as Slicers, instead of using them from Test_data table.
Here is the modified pbix file for your reference. :smileyhappy:
Regards
Hello v-ljerr-msft,
Is there a way to calculate this within the same table (test_data). I need to use year scenario for other visual also and there should be an interaction between all the visualization.
I created a new table Measure Dimensions with year scenario(Measure). I created measures for different scenarios and using them in the switch function.
Measure Selection =
SWITCH( TRUE(),
VALUES('Measure Dimensions'[Measure]) = "2015 ACT", [2015 ACT],
VALUES('Measure Dimensions'[Measure]) = "2015 BGT", [2015 BGT],
VALUES('Measure Dimensions'[Measure]) = "2015 FQ1", [2015 FQ1],
VALUES('Measure Dimensions'[Measure]) = "2015 FQ3", [2015 FQ3],
VALUES('Measure Dimensions'[Measure]) = "2016 ACT", [2016 ACT],
VALUES('Measure Dimensions'[Measure]) = "2016 BGT", [2016 BGT],
VALUES('Measure Dimensions'[Measure]) = "2016 FQ1", [2016 FQ1],
VALUES('Measure Dimensions'[Measure]) = "2016 FQ3", [2016 FQ3],
VALUES('Measure Dimensions'[Measure]) = "2017 ACT", [2017 ACT],
VALUES('Measure Dimensions'[Measure]) = "2017 BGT", [2017 BGT],
VALUES('Measure Dimensions'[Measure]) = "2017 FQ1", [2017 FQ1],
VALUES('Measure Dimensions'[Measure]) = "2017 FQ2", [2017 FQ2],
VALUES('Measure Dimensions'[Measure]) = "2017 FQ3", [2017 FQ3],
VALUES('Measure Dimensions'[Measure]) = "2018 BGT", [2018 BGT])
Measure Selection2 =
SWITCH( TRUE(),
VALUES('Measure Dimensions'[Measure]) = "2015 ACT", [2015 BGT],
VALUES('Measure Dimensions'[Measure]) = "2015 BGT", [2016 BGT],
VALUES('Measure Dimensions'[Measure]) = "2015 FQ1", [2016 FQ1],
VALUES('Measure Dimensions'[Measure]) = "2015 FQ3", [2016 FQ3],
VALUES('Measure Dimensions'[Measure]) = "2016 ACT", [2016 ACT],
VALUES('Measure Dimensions'[Measure]) = "2016 BGT", [2015 FQ3],
VALUES('Measure Dimensions'[Measure]) = "2016 FQ1", [2017 FQ1],
VALUES('Measure Dimensions'[Measure]) = "2016 FQ3", [2015 FQ3],
VALUES('Measure Dimensions'[Measure]) = "2017 ACT", [2016 ACT],
VALUES('Measure Dimensions'[Measure]) = "2017 BGT", [2016 ACT],
VALUES('Measure Dimensions'[Measure]) = "2017 FQ1", [2018 BGT],
VALUES('Measure Dimensions'[Measure]) = "2017 FQ2", [2017 BGT],
VALUES('Measure Dimensions'[Measure]) = "2017 FQ3", [2017 BGT],
VALUES('Measure Dimensions'[Measure]) = "2018 BGT", [2017 FQ3])
This is working if there is no relation between Test_data & Measure Dimensions.
I want to use year scenario as a filter and all the visualization should change based on filter selection.
Any suggestions are appreciated.
Thanks
Hi, did you ever find a solution?