Forum Discussion
User Input table or List
I have price data in a Power Bi report based off all of our part numbers. Currently, my report allows users to filter by part number via an Atribute Slicer. Is it possible for allow a user to load a table or list of part numbers and the data filters to these part numbers only. Basic version below.
Power Bi report
Part Number | Price |
| Part1 | 115 |
| Part2 | 205 |
| Part3 | 67 |
| Part4 | 25 |
| Part5 | 13 |
User Input
| Part Number |
| Part2 |
| Part5 |
Result
| Part Number | Price |
| Part2 | 205 |
| Part5 | 13 |
Thank you for your help. I found this filter and it works perfect.
Paste in the items you want, click the filter icon, and it filters the list.
2 Replies
Hi Pretengineer ,
If the filtered data type is Numeric, you can refer to this blog below to implement it by using what if parameter.
Creating User Input Variables in a Power BI Report
But it seems that the value of the field as the filter item is Text type, then please check the following visuals to see if it can achieve your needs. Please find the details in the attachment.
Best Regards
Thank you for your help. I found this filter and it works perfect.
Paste in the items you want, click the filter icon, and it filters the list.
