Forum Discussion
Filter and Visualize Historical Data Using Slicers
I have 3 tables: A Countries and Groups table that contains a list of countries and the respective Groups they belong to. This table has countries that can have duplicate or triplicate entries due ...
HI jytech,
Please share some dummy data with the expected result to help us clarify your data structure and test coding formula on it.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin SHeng
Scenario 1:
- Spain is selected from the Country slicer.
- In the Group slicer (column in same table as Country), it displays Group A because before 11/30/2019 it was part of Group A.
- The Date slicer (DAX created calendar) shows 1/1/2018 - 11/30/2019 and all the data/metrics for that timeframe. For example: Users 1,408 and etc.
Scenario 2:
- Spain is again selected from the Country slicer.
- In the Group slicer (column in same table as Country), it displays Group B because after 11/30/2019 it is now part of Group B.
- The Date slicer (DAX created calendar) shows 1/1/2018 - 11/30/2019 and all the data/metrics for that timeframe that correspnd to the date range selected. For example: Users 930 and etc.
As mentioned in my original post, as an added bonus, it would be great to be able to report Group metrics based on the above. For example, if I select Group A my report will include Spain from 01/2000 to 11/2019, however shouldn't include Spain from 12/2019 and beyond because they are now part of Group B.
Does this make more sense? Can anyone help?