gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,341
- Office Version
- 365
- Platform
- Windows
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:
Thank you for your time and help!
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 |
