Forum Discussion
zzammit
4 years agoNew Member
Syncing Different Slicers
Hello everyone, I am trying to create a synced date slicer between two pages, but slices a different date column on each page. In this particular section of my report I have two pages that are th...
- 4 years ago
Hi zzammit ,
To make this sync between pages you need to follow the advance sync on sync separate slicers:
Another option is to create a measure that is similar to the one below you can use it on your specific page:
Measure = CALCULATE(SUM(Table[Column]), USERELATIONSHIP(Table[DueDate], Calendar[Date]) )If you use this measure on your visualizations then you can filter by the date in both pages and the slicers will sync.
MFelix
4 years agoSuper User
Hi zzammit ,
To make this sync between pages you need to follow the advance sync on sync separate slicers:
Another option is to create a measure that is similar to the one below you can use it on your specific page:
Measure = CALCULATE(SUM(Table[Column]), USERELATIONSHIP(Table[DueDate], Calendar[Date]) )
If you use this measure on your visualizations then you can filter by the date in both pages and the slicers will sync.
zzammit
4 years agoNew Member
Following the steps under the link provided worked wonderfully, thank you!