Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 |
Solved! Go to Solution.
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
3 | |
3 | |
3 | |
3 |