Forum Discussion
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-...
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
Fantatic!
Thanks v-jiascu-msft
I change a little "Scenario" column:
Scenario =
IF(SEARCH("likely";[Likelyhood];1;0)>0 || SEARCH("hopeful";[Likelyhood];1;0)>0 ;"High";
IF(SEARCH("expected";[Likelyhood];1;0)>0;"Base";
IF(SEARCH("certain";[Likelyhood];1;0)>0;"Low";
"Error"
)//high
)//base
)//low
And THIS is a cAsE independent solution.
Best regs