Forum Discussion
Multiple Similar Dashboards - Replicate Changes
Hi PowerBI Community,
My company manages buildings and we are creating dashboards for each building under management. Each building would have the exact same charts, wordings and the data from each dashboards come from the same data source. The only difference in each dashboard is the filtering of the data (Site A would have Site A selected, Site B would have Site B selected) and some minor wording change (Site A as the header for Site A and Site B as the header for Site B).
The only problem that I am facing right now is; for any changes in the dashboard, the same change has to be replicated manually on all the other dashboards. Would the PowerBI community have a better solution for this? Say like a "Master Dashboard" that ensures changes reflected in the "Master Dashboard" is reflected in the other dashboards as well?
Thank you PowerBI Community
Hi ShafiqRuslan,
I think you should do it like this.
1. Get data from data source and create a report For site A and publish it to Workspace 1.
2. Refilter the data in the reprot that we created just now for site B and publish it to Workspace 2.
3. Create two dashaboards seperatly in Workspace 1 and 2.
Regeards,
Frank
Hi ShafiqRuslan
1. Get data from data source and create a report For site A and publish it to Workspace 1. Here we named the report for site A.
2. Save and copy the pbix and renamed the copy one to site B, open it and edit it (filter). Then publish it to the Workspace 1.
3. Then you can use the two reports site A and site B to create dashboard as you need.
Please notice here we needn't publish reports to different workspace.
Regards,
Frank
7 Replies
Hi ShafiqRuslan,
Here I suggest you to publish different reports to different app workspace. Then you can create the dashboard accrodingly in the app workspace. For example, Site A to app workspace A, site B to app workspace B.
Regards,
Frank
That's a great solution. However, does this mean that I have to filter out the data from each workspaces to reflect what's on that particular site?
Hi ShafiqRuslan,
You can filter the data what you want in the report, not the data source.
Regards,
Frank
