Filter with search option

[Kris4815]

I am creating a report in Reports Builder. I'm making about 30 slicers in the report but I'm having a problem with one of them. This is a column with id_produkt. There are approximately 5 million unique entries in this column. The Paginated Report works by loading all elements in the "fragmentator" visualization, which puts a heavy load on the Power BI tenant, which makes the entire report run very slowly.

How should I create a slicer in .rdl that will have the option to search for a specific produkt_id?

[Anonymous · Accepted solution]

Hi @Kris4815 ,

Unfortunately, native support for a search box within a slicer in .rdl (Paginated Reports) is limited. You can achieve a similar outcome by using parameters and filters to allow users to input or select specific values. This approach reduces the need to load all entries simultaneously, improving performance. 

More details:Filter equation examples in a paginated report - Microsoft Report Builder & Power BI Report Builder ...

Create and use the paginated report visual - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.