Scenario analysis: Predefined and user-controlled

[seanstead]

Hello everyone

I'm creating some scenario analysis for Altman Z (a company's financial risk), and I've successfully created 2 rodables: EBIT change and sales change. code as follows:

Public changed scenario ?

SUMX( 'AltmanZ (Public)' ,

'AltmanZ (Public)'[Earnings before interest and taxes] * ( 1 + [EBIT Scenario] ) / 'AltmanZ (Public)'[Total Assets] ) * 3.3 +

"AltmanZ (Public)",

'AltmanZ (Public)'[Working Capital] / 'AltmanZ (Public)'[Total Assets]) * 1.2 +

"AltmanZ (Public)",

'AltmanZ (Public)'[Retained Earnings] / 'AltmanZ (Public)'[Total Assets]) * 1.4 +

"AltmanZ (Public)",

'AltmanZ (Public)'[Wealth Market Value ] / 'AltmanZ (Public)'[Total Liabilities]) * 0.6 +

"AltmanZ (Public)",

'AltmanZ (Public)'[Sales] * ( 1 + 'Percentage of Sales Change'[Sales Scenario] ) / 'AltmanZ (Public)'[Total Assets] * 0.999 )

Problem:

my current solution is controlled exclusively by the user. I'm looking to have 2 options - user-controlled and predefined. For presets, I want 3 options: that for each one I would select to say:

option 1: Bit change -10% and change sales -10%

option 2: Bit change -30% and sales change -30%

option 3: Bit change +20% and sales change + 20%

How do I have a preset switch and user control? and then set option 3 to preset?

Thank you!

[v-easonf-msft]

Hi , @seanstead 

As for bookmark function,pls refer to these documents:

bookmark

link bookmark to button 

Best Regards,
Community Support Team _ Eason

[Greg_Deckler]

See response here: https://community.powerbi.com/t5/Desktop/Scenario-analysis-predefined-and-user-controlled/m-p/106413...