Establish new relationships for benchmarking

[MSC]

Hi there!

In my report, I use a straightforward slicer-visual "current report" page but also another one on which I do some benchmarking comparing data from different companies (please see the attached pbix file).

What I would like to do now is to sync the company slicer on the "current report" page with that of the (focal) company slicer on the "new report" page.

This is because at the moment I have to select the focal company on my benchmarking page (which here is called "suggestion by link" because it follows v-xulin-mstf `s solution) manually.

Example: I select Danone SA on "current report", then the first slicer on "new report" should also display Danone SA and I should be able to add some peers thereafter.

Please find attached the corresponding
pbix file and
excel file (if dataset is needed).

The demo file has the same underlying model as my original pbix file.

Is there a possibility with which this can be solved? I have tried to tackle it with establishing new relationships between the different datasets but was not able to come to a solution.

Thank you very much in advance for any help!

[V-lianl-msft · Accepted solution]

Hi @MSC ,

Try using the sync slicer feature:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers 

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