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 d...
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 

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.