Forum Discussion
Trying to return a value based on a Slider
Hi Anonymous,
In your situation, I recommend utilizing What-If parameters as a solution. What-If parameters enable you to define variables within your reports, interact with these variables like slicers, and visually represent and quantify various important values in your reports.
Since the exact formula for calculating costs for different bill rates has not been mentioned, for now, I can suggest you go through the following links and see if you can use the parameters to achieve your requirements -
- https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
- https://ploiitubsamon.medium.com/a-step-by-step-guide-on-creating-what-if-analysis-in-power-bi-c5c09def5cf5
- https://blog.enterprisedna.co/scenario-analysis-using-what-if-parameters-in-power-bi/
Note: What-If parameters are now called New Parameters in Power BI Desktop
Let me know if it helps!
Hi Anonymous,
In your situation, I recommend utilizing What-If parameters as a solution. What-If parameters enable you to define variables within your reports, interact with these variables like slicers, and visually represent and quantify various important values in your reports.
Since the exact formula for calculating costs for different bill rates has not been mentioned, for now, I can suggest you go through the following links and see if you can use the parameters to achieve your requirements -
- https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
- https://ploiitubsamon.medium.com/a-step-by-step-guide-on-creating-what-if-analysis-in-power-bi-c5c09def5cf5
- https://blog.enterprisedna.co/scenario-analysis-using-what-if-parameters-in-power-bi/
Note: What-If parameters are now called New Parameters in Power BI Desktop
Let me know if it helps!
Hi Bipin-Lala,
I am trying to calculate the bill rates based off the selected value in the slicer