Forum Discussion
Dynamic Parameters in PBI report
Hi Guys,
I’d like to ask you for some advice on a certain topic. I’m building a report that will consist of visualizations of sales results. Historical sales data will be pulled from the store database. Future sales should be forecasted using parameters and calculated dynamically based on changes to those parameters.
For example, a parameter like "sales growth in 2027" should trigger a recalculation of 2026 sales multiplied by the growth factor (parameter).
Additionally, I’d like to simulate the opening of new stores using parameters such as: number of stores, average sales, opening date — and then add the resulting sales to the total sales.
How should I approach this?
Thank you in advance for your help.
ktrk
Hello katromank
you can define the parameters as numeric ranges, that will automatically create a table of values for each, a slicer for each and a measure to capure the selection of each, all automatically and dynamically
Then, in your measure like Sales 2027 you will write = [Sales 2026] * (1 + [Values SalesGrowth2027] )
where Values SalesGrowth2027 is the automatically generated measure capturing the selected value of the parameter SalesGrowth2027, make sure the slicer has a single selection
Best
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi katromank ,
Create What-If Parameters in Power BI for sales growth, number of new stores, average sales per store, and opening date.
Write DAX measures that reference these parameters to dynamically calculate forecasted sales.
Add slicers for each parameter so users can adjust and instantly see updated forecasts in your visuals.
This setup lets you model scenarios and see the impact in real time, all within Power BI, whilst also no external tools needed.
2 Replies
Hello katromank
you can define the parameters as numeric ranges, that will automatically create a table of values for each, a slicer for each and a measure to capure the selection of each, all automatically and dynamically
Then, in your measure like Sales 2027 you will write = [Sales 2026] * (1 + [Values SalesGrowth2027] )
where Values SalesGrowth2027 is the automatically generated measure capturing the selected value of the parameter SalesGrowth2027, make sure the slicer has a single selection
Best
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi katromank ,
Create What-If Parameters in Power BI for sales growth, number of new stores, average sales per store, and opening date.
Write DAX measures that reference these parameters to dynamically calculate forecasted sales.
Add slicers for each parameter so users can adjust and instantly see updated forecasts in your visuals.
This setup lets you model scenarios and see the impact in real time, all within Power BI, whilst also no external tools needed.