Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Manual entry Pricing Report

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.

Tutorial Requests

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    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.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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])