Forum Discussion
Using One Slicer to Filter Date Fields Across Multiple Tables
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.
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.