Forum Discussion
Anonymous
3 years agoNot applicable
How to create one date slicer with multiple date fields from multiple tables
I have three tables in my report. Each table has a date field. I would like to create one date slicer that will control all three tables, however, in each of my tables the date fields have different names- Transaction Date, Received Date and Transaction Date. I have tried synching and grouping the slicers but it does not control all three tables. Here is my sample report.
Here is my model. I have all three talbes connected to the date table.
Any help would be greatly appreciated. Thank you in advance!