Forum Discussion

TSG123's avatar
TSG123
New Member
2 years ago
Solved

Pre-selecting Slicer Options when using Secure Embed

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.