The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
I have created a 2 tables called:
"Manager" with GenerateSERIES (0,2,.5) and then created a slicer with that table
"Senior" with GenerateSERIES (0,10,.5) and then created a slicer with that table
I am trying to get the value of each slicer into the a different table called "Pricing" which then would be used to calculate the cost based off Manager and Senior bill rates
The thought is that anyone could access the report, adjust the slicers, hit refresh and new numbers would be calculated based off of their input...
Please let me know if you need anything else to help!
Solved! Go to Solution.
Hi @WlConley,
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 -
Note: What-If parameters are now called New Parameters in Power BI Desktop
Let me know if it helps!
ok, sounds good. What happened when you used SELECTEDVALUE ?
Hi @WlConley,
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 -
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
96 | |
80 | |
62 | |
56 |
User | Count |
---|---|
256 | |
120 | |
112 | |
83 | |
71 |