Power BI Visual / Filter

[gheyman]

I have a table that has unit prices. Each row will have a Part number with a From Quantity and a To Quantity. Is there a way for the user to filter the table to find only data for a specific quantity that they are looking for?
Lest see the user only wanted to see the data where there is a price for Quantity 8 (The results should be a filtered table with Rows 2 and 4). I have no idea how to achieve this. I am only guessing some kind of visual/slicer... relatively new to Power BI. PS I work for a company so I cannot use visuals that you have to pay for but I can load the free visuals from "Get more Visuals"

Example table:

Part Number	FromQty	ToQty	Unit Price
ABC123	1	5	$100.00
DEF456	1	25	$125.00
GHI789	25	75	$95.00
ABC123	8	8	$98.00

Thank you for your time and help!

 

[gheyman]

Also, I cannot create another table for the users to enter data. The report will be out on a server where IT refreshes it nightly. The user will not be able to refresh. So an Excel table will not really work - I think.