Forum Discussion

scottda4270's avatar
scottda4270
Helper I
2 years ago
Solved

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 sam...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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's avatar
scottda4270
Helper I
2 years ago

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