https://store-images.s-microsoft.com/image/apps.31640.5db00ad5-3afd-4564-9eae-5177e26eb6b0.6e6935ce-bbae-4b42-8032-7fcaf6f2d5ee.c078c1fb-160b-45c5-9a24-24a1c45d71ec

Filter by List

by DEVSCOPE

Microsoft PBI Certified
(46 ratings)
Download SampleInstructions

Apply filter values to a report in bulk instead of individually checking each box in the filter pane

Filter by List is a Power BI Visual that allows users to apply filter values to a report in bulk instead of having to individually check each box in the filter pane. By default, to filter a report with many categories, users need to individually check each box in the filter pane. This is a tremendously time-consuming task when you have 100s of products, which is a common scenario for many clients.

Filter by List lets you apply:

  • an Inclusion filter: add the whole list of products into the slicer visual to instantly filter by them.

  • an Exclusion filter: paste the values you don't want to see into the slicer visual to display the rest.

Filter by List uses a flexible pricing model based on your needs and a free version that lets users filter up to 20 values.

Limitations apply when a user shares a filtered report using Filter by list:

  • If a user with a license shares a filtered report with another user with a license, both will be able to interact with the report.

  • If a user with a license shares a filtered report with more than 20 items, with another user without a license, the latter will only be able to use the current saved filters or create new filters up to 20 values.

Keep in mind

The following Power BI environments are not supported by visuals with a licensing model:

  • Embedded - Publish To Web, PaaS embed
  • National/Regional clouds (Depends on general support for transactability in national/regional clouds)
  • Report Server (On-Premise) environment
  • Exporting (PDF\PPT) using REST API

Visual capabilities

This visual is certified by Power BI

At a glance

https://store-images.s-microsoft.com/image/apps.2128.5db00ad5-3afd-4564-9eae-5177e26eb6b0.be10c4a6-48fe-4896-8875-28c344a99c8a.535d0c15-afdf-4457-8d28-dc1abb2225f5
/staticstorage/23fd3d2/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.2128.5db00ad5-3afd-4564-9eae-5177e26eb6b0.be10c4a6-48fe-4896-8875-28c344a99c8a.535d0c15-afdf-4457-8d28-dc1abb2225f5
https://store-images.s-microsoft.com/image/apps.4521.5db00ad5-3afd-4564-9eae-5177e26eb6b0.be10c4a6-48fe-4896-8875-28c344a99c8a.5aee2796-9917-4071-bf71-74fce2719171
https://store-images.s-microsoft.com/image/apps.33976.5db00ad5-3afd-4564-9eae-5177e26eb6b0.be10c4a6-48fe-4896-8875-28c344a99c8a.b598d386-4f96-4ee2-b252-33810b8fbbf8