Skip to main content
Microsoft Idea

Power BI

New

Paste List of Values into Filter in Filter Pane

Vote (13) Share
Cody Wimmer's profile image

Cody Wimmer on 25 Feb 2022 15:33:07

Add feature to take a list to filter in the filter pane.


Example: List of 100 customers as .txt or .csv file can be pasted in the filters pane to filter the data for a front end user.

Comments (1)
Cody Wimmer's profile image Profile Picture

Matthew Sharp on 18 Mar 2022 17:13:41

RE: Paste List of Values into Filter in Filter Pane

One work around I found was a discontinued Visual Filter by 'DevScope' called 'Filter by List by DevScope'.If you can obtain the file from the developers, you can then import into your Power BI desktop app and use.It will only filter things on the page it is placed on, however if you connect it to a synced slicer you can control multiple pages. There are some bugs with the multi-page approach but depending on your needs it may be insignificant.It's frustrating that this isn't a standard feature in Power BI filter pane. I would love to see it included in the near future, unfortunately for now this has resulted in my team using alternate software for some projects.