Challenge with slicers

[scottda4270]

Hi all. I have a 6 page report. Each page is populated from a different data set. On each page I have a common looking slicer based on month and year. But of course the slicers whilst looking the same are not related at all. I am looking to see if there is a simple way to link these so if I select July 2024 in one page, the other slicers are synced to the same selection. I looked at slicer sync but from my understanding that has to be the same physical slicer over multiple pages. Sorry if this is a dumb question, self taught over the last couple of months. Thanks. 

[Ritaf1983 · Accepted solution]

Hi @scottda4270 

Since you haven't provided an example, I can only give a general response.

Assuming you have a standard star schema model with one calendar table linked to various other tables, as shown in my screenshot.

You can replicate the slicer across the sheets and synchronize them.

Result:

if you want the slicers to be hidden on some pages it is possible too :

Result :

Pbix with an examples is attached.

More information about syncing dates is by the link :

https://www.youtube.com/watch?v=HCXSlZ9fRTw

Otherwise, to explore alternatives, I would need to see your file and understand the structure and your intended actions.

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

[scottda4270]

Hi @Ritaf1983  thank you for your help...you got me going in the right direction. I created a new data table repliacting my date fields and then created relationships in the model. Then redirected my slicer to the new table and copied/sync across the reports... Sorted. Thank you so much. Still learning and first time I have looked at relationships in the model, much to learn! thanks again. 

[Ritaf1983]

Happy to help ☺️

[scottda4270]

Hi and thank you. I work for a finance company and am not permitted to share the data or pbix file in its current state. If I removed sensitive information there would be very little left of the files. I was hoping my explanation of the issue would be sufficient to see if there was a potential solution but understand why you have asked for this information. Thanks