Forum Discussion
Sync 2 date filters
Community Championcreate a separate date field that has joins with these two and create a single slicer. Why do you need 2 slicers if they're supposed to show the same values?
1 looks at the date something was invoiced the other looks at MRR date looking at each month, i have tried to do the date table then relationship but because i already have relationships between the other tables am unable to do this
i need to create the relationship between Rev by Territory to Date and Query 1 to date but obviously unable to do this?
- Stachu
assuming the existing joins are on the Order ID you should be able to do this when you switch the order of existing joins to single direction rathen than both
thank you, but i need to be able to filter both ways otherwise it messes with the numbers i need