Pre-selecting Slicer Options when using Secure Embed

[TSG123]

Hi all,

Really appreciate any help on this.

My organisation has a shared Power Bi report which analyses data for response times and overall performance of a large number of agencies we need to work with.

We have a number of internal portals we communicate in that support embedded content, so was hoping to secure embed the report on each of these portals with the report slicers pre-selected to show data relevant to whichever agency the portal belongs to (FYI, there are over 30 agencies in the data set). 

My coding abilities are pretty limited, but havent yet cracked whether there is a way to alter the iframe code to make this work. 

Ideally we'd preselect 4 of the slicers (financial year, financial quarter, organisation and agency).

Thanks for any feedback!

[Anonymous · Accepted solution]

Hi @TSG123 ,

Filters can be applied directly to the report URL used for embedding in an iframe, so that the slicer can be preconfigured by passing the appropriate filter value in the URL. For example:

 <iframe width="800" height="600" src="https://app.powerbi.com/reportEmbed?reportId=xxxxxx&groupId=xxxxxx&$filter=YourTable/YourField eq 'YourValue'" frameborder="0" allowFullScreen="true"></iframe>

You can refer to the documentation:
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

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