Hello
Trying to do something that would be very easy in excel (maybe in power bi too). I want to have a field where the user can select the discount %. I then want to use that discount figure to show the sales price. The user would be able to put anything from 0-100% in the discount field/box. What is the easiest way to do this?
create a numeric range .you can set the min , max and the increment. ( 1, or 0.1 ..etc.. )
this will create a table ( in the image above called Paramter ) with one field.
then create a measure =
selectedvalue( Paramter[field_name]) , 1 )
then in your measure that calculates the sales price, you can multiply by the above measure,
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
create a numeric range .you can set the min , max and the increment. ( 1, or 0.1 ..etc.. )
this will create a table ( in the image above called Paramter ) with one field.
then create a measure =
selectedvalue( Paramter[field_name]) , 1 )
then in your measure that calculates the sales price, you can multiply by the above measure,
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
the field name is the name of the column name created when creating the range .
like in my exmple,
the name is Paramter, so : selectedvalue(paramter[Paramter])
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
