Forum Discussion

Helper I

8 years ago

Solved

Scenario Help

Hi- I have data that is organized by project in rows with a column of expectations of likelyhood. Certain Expected Likely Hopeful I need to then be able to sort this data into 3 scenarios-...

Need Help

v-jiascu-msft
8 years ago
Hi charles_o,

You can try the approach of McCow. Another method.
1. Create a middle table for all the scenario.
Scenario
Low
Base
High
Low,Base
Low,High
Base,High
Low,Base,High
2. Create a table for slicer.
SlicerScenario
Low Low
Base Base
High High
Low Low,Base
Base Low,Base
Low Low,High
High Low,High
Base Base,High
High Base,High
Low Low,Base,High
Base Low,Base,High
High
Low,Base,High
3. Create relationships and change the filter direction to Both.

Best Regards,
Dale

charles_o

Helper I

8 years ago

This is the set up for my data. Currently I have graphs, I am using the "slicer" in table3. When I toggle to "Low" on the slicer, it still shows all the data. However, looking at Table3, we can see that "Low" is only related to "Low,Base,High".

Does not make sense, since I do not see how that should bring up my other scenarios.

Relationship