Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Everyone,
So I'm currently working on a pricing analysis dashboard for my company and I know that eventually they will be asking if it is possible to manually enter prices into the dashboard and have the visualizations show the end results. The best idea I could come up with is to create a pricing slicer to adjust the product price but I'm not sure how to use this slicer as the price so the visualization tiles can reflect how the output changes.
If anyone has an idea on this, please share. Thanks for your help.
Solved! Go to Solution.
I think you need what if parameter. Check following
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
https://radacad.com/power-bi-what-if-parameters
hi, you could create a measure that takes your base price and multiply it by a factor, and using a slicer you could control de factor to multiply your base price.
measure
I think you need what if parameter. Check following
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
https://radacad.com/power-bi-what-if-parameters
@Anonymous you can use what-if parameter to change pricing, let's say you want to give the range to change price from -50% to +50%. with what-if you can set the range and then use value of what-if parameter to calculate the projected price and also the sales.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |