Forum Discussion
Filter with search option
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?
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 | Microsoft Learn
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 | Microsoft Learn
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.