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

Forum Discussion

Scenario Help

Related content

Data Filter Scenario

Scenario mapping table

Azure Analysis Service Migration Scenarios

Actuals and forecasts - scenarios

Variances between Scenarios

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