Forum Discussion
What-If Parameters - Using it to calculate new columns dynamically.
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!
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/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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
3 Replies
- Ritaf1983
Super User
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/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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
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
