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'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.
Thank you KNP. I absolutely agree! For now I've been working with what I've been provided but have expressed some challenges with modelling the data in a more efficient, way. Since it's historical data that has now become static (point in time data, that will not change), scalability is not required.