Forum Discussion
Using One Slicer to Filter Date Fields Across Multiple Tables
Hello All, I have a time/labor report that references four tables... these tables are joined by employeeID. Each table has a date field related to the specific timesheet transaction. Since I have...
I figured out a very simple solution which is to just add each of the date fields from each dataset to the same slicer group and that works very well.
The correct approach is to have a date table (don't forget to mark it as a date table) and join on that.
Can you show us a screen shot of your model?
I suspect there's something else going on.
I figured out a very simple solution which is to just add each of the date fields from each dataset to the same slicer group and that works very well.