Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
7 | |
7 | |
3 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |