Trying to solve a problem which looks very simple, but not really!
I have a data set in the below format and need to create a scatter plot with scenario 1 on the y axis and scenario 2 on the x axis (Material in the level of detail). The user can choose to compare between any two scenarios from the tableau dashboard. The number of scenarios are not fixed, will change every time the underlying data changes.
I implemented this using parameters, however I want to avoid using them as they are not dynamic.
Any help is much appreciated. I have attached the sample twbx file.
To my knowledge parameters are the only way to implement this type of solution. The reason is because you use the phrase "user can choose", which, in Tableau, the only way you can set this up for a single dimension is via a parameter.