Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
scottda4270
Helper I
Helper I

Challenge with slicers

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. 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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.

Ritaf1983_0-1720579741345.pngRitaf1983_1-1720579840662.png

 

Result:

Ritaf1983_2-1720579982607.pngRitaf1983_3-1720580100896.pngRitaf1983_4-1720580206839.png

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

Ritaf1983_5-1720580538609.png

Result :

Ritaf1983_6-1720580566639.png

 

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.

 

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

4 REPLIES 4
Ritaf1983
Super User
Super User

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.

Ritaf1983_0-1720579741345.pngRitaf1983_1-1720579840662.png

 

Result:

Ritaf1983_2-1720579982607.pngRitaf1983_3-1720580100896.pngRitaf1983_4-1720580206839.png

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

Ritaf1983_5-1720580538609.png

Result :

Ritaf1983_6-1720580566639.png

 

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.

 

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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. 

Happy to help ☺️

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
scottda4270
Helper I
Helper I

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.