Extensive what-if/sensitivity analysis

[AMLAZUD]

Hello, I only recently started exploring PowerBI. I am looking for a way to perform a very comprehensive what-if/sentivity analysis:
there are a lot of values in our model (100+?) that influence cost/profit. Thanks to a sensitivity analysis, we want to determine which of these values exerts the greatest influence on cost/profit.

For example: if we want to reduce our costs by 20% by 2030, is there a way to determine which of all the related values will have the biggest input on cost and therefore where we need to work the most?

[v-jianboli-msft]

Hi @AMLAZUD ,

How to determine which of these values exerts the greatest influence on cost/profit?

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.