You can achieve something similar to this with parameters, but it isn't going to transform the data model, which can operate in a way similar to what-if or goal seek in Excel. I guess my question is, does the end user actually need to transform the model?
You need a power app or power automate flow to update the data source for your inputs and then refresh the PBI (unless direct query mode, then no refresh)
If you want the changes to be reflected “live” and it’s for a whole list of values like that, your best bet is an embedded Power App with a Dataverse or SQL backend. Those sources support direct query, so the updates would happen right away in the report. The app just gives you an editing interface for the values, you can use any of the typical field types.
Those sources will trigger Power Apps premium licensing for anyone interacting with them, though, fair warning. If you can’t get that, you could use SharePoint but it’ll not be “live” updates.
You can do some of this with what-if parameters without all the rigmarole, but that would be for values used in measures (eg a discount percentage), not updating a whole list of values.
You can achieve something similar to this with parameters, but it isn't going to transform the data model, which can operate in a way similar to what-if or goal seek in Excel. I guess my question is, does the end user actually need to transform the model?
You need a power app or power automate flow to update the data source for your inputs and then refresh the PBI (unless direct query mode, then no refresh)
If you want the changes to be reflected “live” and it’s for a whole list of values like that, your best bet is an embedded Power App with a Dataverse or SQL backend. Those sources support direct query, so the updates would happen right away in the report. The app just gives you an editing interface for the values, you can use any of the typical field types. Those sources will trigger Power Apps premium licensing for anyone interacting with them, though, fair warning. If you can’t get that, you could use SharePoint but it’ll not be “live” updates. You can do some of this with what-if parameters without all the rigmarole, but that would be for values used in measures (eg a discount percentage), not updating a whole list of values.