Is it possible to add a field in the PowerBI dashboard that is connected to a formula in Power Query

[MarcoW91]

Hi all,

I am trying to get a button in which I can create simulations on the dashboard page op PowerBI in where I can customly add a percentage change e.g. prices change by x % and costs per category change by % percent and I am trying to find a solution to let the user do this on the dashboard. Is this possible and if so how can this be achieved?

So it would be a dynamic scenario calculator in which the user can modify the parameter easily on the dashboard.

Any help would be greatly appreciated.

KR,

Marco

[Anonymous · Accepted solution]

Hi Marco,

You have 2 options:

1. Use What if parameter: for this you can move your calculation to DAX instead of Power query. Go to Modeling Menu and choose "New Parameter" on the ribbon.

2. Use Power Query parameter and bind to the data model. This works in DirectQuery models only.

I would suggest to go for 1st option - should be faster. You can share your Power BI file if you need more help on the solution.

[MarcoW91]

Thanks!