Forum Discussion
What-If Parameters - Using it to calculate new columns dynamically.
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
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
Super User
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