Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
My organization, we create dashboards on Power BI Desktop, and then publish to host on Power BI Server. I would like to know if there's a possibility, that output of one dashboard, can be treated as an input to another dashboard?
Example:
Dashboard 1: Creates a list of the clients according to filters used.. User then clicks on a button (or any other way), to open the Dashboard 2
Dashboard 2: Uses the Dashboard1 output as input, and filters the metrics accordingly..
Hi,lbendlin ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@anshus .I am glad to help you.
If the effect you want to achieve is for Power BI Service, then your needs can be realized:
Data transfer and interaction between dashboards and reports in Power BI Service.
Since a dashboard can contain multiple reports and the content is not fixed, URL Filters does not support dashboards, but rather reports.
You can put the report URL used in the second dashboard as a button in the first report.
Or you can use the link in the dashboard (you need to make sure that the admin portal is enabled).
Here are my tests:
Operations in power BI Desktop("Creating url buttons in report" function)
Copy the report url of the second dashboard (the report itself, not the dashboard).
After my testing the url filters only work for the report but not for the dashboard, this is something you need to be aware of.
create the jump rul measure (to report2 )
It is important to note that some special symbols such as single quotes and spaces need to be escaped.
URL:
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
meausre code:
JumpURL =
"https://app.powerbi.com/groups/xxxYourGroupIDxxx/reports/2825de85-adf5-4e84-bd8b-ea0514420a29/eba9e747ea0da7e5db78?filter=datarefreshTest%2Fanimal%20eq%20%27"&[SelectAnimal]&"%27"
You can either add a jump button to the report used by dashboard1 (to select the web URL), or add a web contant to the dashboard
ADD URL button
Select the URLmeasure we just created
[JumpURL]
At this point you can first test on Desktop, when the slicer is selected, the measure passes the value from the slicer to the URLmeasure, which is then loaded by loading it into the button and then clicking the button to realize the jump to report 2
Finally, republish the modified report1 to the service and pin it to the dashboard to realize the url jumping
Please note that url filters only work for reports, not for dashboards.
I hope that the following issue will be of help to you:
URL:
Solved: Salesforce URL to Open and Filter Power BI Report ... - Microsoft Fabric Community
Unfortunately dashboards don't support the use of URL Filters to enable the carrying of filter parameters (passed to another dashboard)
URL:
Solved: apply filters within the dashboard??? - Microsoft Fabric Community
In addition to the measure URL Filters approach I've provided above, you may also want to consider using the cross-report drilling feature.
URL:
Solved: Pass a filter parameter from one PBI dashboard to ... - Microsoft Fabric Community
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Power BI Report Server does not support dashboards. Did you mean to say Report?
Power BI Report Server also doesn't support the notion of a semantic model.
Your second report would need to use the same sources as the first one.
Hi, Thanks for responding. I just went and checked - it is a online "Workspace", and reports are build in power BI desktop application.
Then yes, you can connect to to a Power BI Semantic Model from your Power BI Desktop.