topic Re: User Input table or List in Developer

User Input table or List

Pretengineer — Tue, 21 Mar 2023 18:43:41 GMT

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

Re: User Input table or List

Anonymous — Thu, 23 Mar 2023 07:18:13 GMT

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.

Text Filter

Smart Filter Pro by OKViz

Best Regards

Re: User Input table or List

Pretengineer — Thu, 23 Mar 2023 16:17:30 GMT

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.