Interactive Matrix & Line Chart

[connorli]

Hi I'm looking to build a fairly dynamic matrix that calculates the difference between two selected scenarios (selected out of 20 scenarios or so) that also interacts with a line graph. I've included a snapshot of my current dashboard. This is exactly how I want the dashboard to look, except I would like to have a third column that shows difference amount between the two scenarios in each matrix. The values and scenarios are coming from the data table in the second screenshot (and just in case it's relevant, the category matrix data is pulling from the same table and another table in order to label the data in the first two columns differently.) I'm not sure what the best/most efficient way to do this would be. Any help or advice would be greatly appreciated! Thank you!

[amitchandak · Accepted solution]

@connorli , Based on what I got, refer if this approch can help

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc