Manual entry Pricing Report

[Anonymous]

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.

[Anonymous]

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

new price = SUM('Table'[Price])* MIN('Table (2)'[range])

[amitchandak · Accepted 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

[parry2k]

@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.