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.
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.
I'm glad you've solved your problem.
It's worth noting, this data model is not following recommended design and dealing with dates that way is not scalable/future proof.
I would recommend reading up on star schemas if you want to build robust solutions.