Forum Discussion

Sidpar24's avatar
Sidpar24
Frequent Visitor
3 years ago
Solved

Interaction between two different date slicers on same page

Hello folks,

I am facing one issue related to syncing of two different date slicers on the same page of report.
There are two different date columns in a fact table,
a.) Creation date b.) Closed date.
both of them belongs to same fact table. I have created two slicers on same page of a report, one for creation date and other one for Closed date.

I want both slicers to work in a sync. Like when i select date range in Creation date slicer then this range should also get passed to the the Closed date slicer automatically. i will hide the Closed date slicer. User will only be interacting with Creation date slicer.

Is there any possible way to sync both the slicers?

I tried Data interaction option too. But that is also not working.

Please suggest any solution to this.
Thanks in advance!!

Regards,
Siddhant

Need Help
  • Sidpar24's avatar
    Sidpar24
    3 years ago

    Hi amitchandak ,

     

    Thanks for the the solution.

    But i have found another approach to solve this issue.

     

    If we have to sync slicers we have to group them under the advance options in the sync slicers settings.

     

    Ex: Suppose we have two slicers, 1st slicer is date created and 2nd slicer is date closed. Both the columns i.e date created and date closed reside in the same table. 

    Now in order to sync them we have to give the same group name to both the slicers. To do so, go to view-> sync slicers -> advantage options -> Group. Give the same group name to both the slicers. Now these two slicers are synced together.

     

    Thanks 

    siddhant parashar 

3 Replies

  • Sidpar24's avatar
    Sidpar24
    Frequent Visitor
    3 years ago

    Hi amitchandak ,

     

    Thanks for the the solution.

    But i have found another approach to solve this issue.

     

    If we have to sync slicers we have to group them under the advance options in the sync slicers settings.

     

    Ex: Suppose we have two slicers, 1st slicer is date created and 2nd slicer is date closed. Both the columns i.e date created and date closed reside in the same table. 

    Now in order to sync them we have to give the same group name to both the slicers. To do so, go to view-> sync slicers -> advantage options -> Group. Give the same group name to both the slicers. Now these two slicers are synced together.

     

    Thanks 

    siddhant parashar 

    • shummel's avatar
      shummel
      New Member
      11 months ago

      I also want to sync my two date slicers though with the same date but with two different formats. I want the one to be relative date and the other to be between but everytime I group them they change to the same type of date slicer either relative or between even when i click on the the box to affect the data not the format in the grouping area.

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Sidpar24 , If you need the same date to be filtered for those dates then you can use date table with active inactive join and userelationship

     

    https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

     

    If the dates from the table are used in the slicer.  They will filter each other, if they are not range slicer 

     

    Same way if you have two dimensions for these dates. You can this technique on nonrange slicers 

     

    dimension to dimenison filter
    Learn Power BI Advance- Abstract Thesis Part 71: How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8