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 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!

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.

1 Reply

  • 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.