What-If Parameters - Using it to calculate new columns dynamically.

[sahus3030]

I would like to use What-If Parameters as user inputs.

I have uploaded some tables with data, but I would like to create new columns to calculate this data with the what-if parameters. However, when I create these columns, the what-if parameter is the default value instead of the user value. 

When I try to link the what-if parameter table with the actual table - I get a circular reference error. 

Appreciate any help here!

[Ritaf1983 · Accepted solution]

Hi @sahus3030 
What if parameters work in the same way as slicers, all calculations are made "on the fright", so there is no option to create calculated columns based on the user's selection, only measures.
Maybe there is another way to achieve the desired results that you need to visualize .

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

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

[sahus3030]

Hi Rita, 

Thank you for your reply. Can I clarify that I will not be able to use the user input from the what-if parameter as a factor to multiply an existing column of data?

2023	40
2024	59
2025	35
2026	53
2027	63
2028	35
2029	63

Based on user input (say 0.4 on the slicer), I want to multiply each value by that dynamically. This is so that my line graph can change by 0.4.

Cheers, thanks for the help thus far!

[Ritaf1983 · Accepted solution]

Hi @sahus3030 
You can :), with measure.
Take a look at the attached pbix with an example that I created.

And at the linked tutorial

https://www.youtube.com/watch?v=6a_5uderwAg

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

[Ritaf1983 · Accepted solution]

Hi @sahus3030 
What if parameters work in the same way as slicers, all calculations are made "on the fright", so there is no option to create calculated columns based on the user's selection, only measures.
Maybe there is another way to achieve the desired results that you need to visualize .

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

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