Pass user login and filtered value to another webpage from Power BI service

[WOLFIE]

Hi

Is it possible to pass a user login and filtered value like an ID to another webpage, please?

I need something like a button that will forward the user to another webpage using the user login which will then prompt the SSO and filter the page by the ID that will be passed from the Power BI report.

Thanks

[Anonymous · Accepted solution]

Hi, @WOLFIE 

We were able to select based on one report and then click the report button to jump to another report and keep the filter. Here's how to demonstrate how to do it:

First, there are the following reports that need to be redirected:

We need to copy the URL of this report:

https://app.powerbi.com/groups/xxxx/reports/xxx/xxx

Design a report with a button and a column that you want to pass parameters to another web page, in my case, I want to pass Product, so the sample data is as follows:

Create a slicer and button:

Create a new measure using the following DAX expression:

URL = "https://app.powerbi.com/groups/xxxx/reports/xxx/xxx?filter=Table/Product eq " &"'"&SELECTEDVALUE('Table'[Proudct])&"'"

The filter is followed by the table/column name of your other report

eq is a fixed spelling, and selectedvalue returns the current slicer option, which is passed to the URL measure. Next, we apply this measure to the button:

Publish the report to Power BI Service. Here are the results:

When I select Apples in the slicer, then clicking on the button jumps to another report and retains the parameters selected by the slicer:

The above is mainly used in the URL filtering report. You can learn how this feature works at the links below:

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

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

[WOLFIE]

Thanks 🙂 I think this is close to what I need! I will give it a go!