Reply
MSC
Helper III
Helper III
Partially syndicated - Outbound

Establish new relationships for benchmarking

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!

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

Syndicated - Outbound

Hi @MSC ,

 

Try using the sync slicer feature:

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

Vlianlmsft_0-1639979862212.png

 


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

View solution in original post

1 REPLY 1
V-lianl-msft
Community Support
Community Support

Syndicated - Outbound

Hi @MSC ,

 

Try using the sync slicer feature:

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

Vlianlmsft_0-1639979862212.png

 


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

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)