Forum Discussion
Slicer cross-filtering not working
Hi Community,
Kindly help diagnose & rectify this issue wherein even if i slice my data for Calendar Year 2019 as shown by Period slicer i the image below- a card "Days in Period" which uses "Calendar table" still shows 1826 days- it should show 365 but not necessarily match with "Travel Days" card as that is coming from another table. I was able to rectify it by changing filter direction to both in the relationship tab between 2 tables. But, later that seemed incorrect as then both the slicers showed same results irrespective of my selection of destination country.
Why is the table "Calendar" not being cross-filtered upon slicer selection? Please help!
File attached too! https://drive.google.com/file/d/1I13Nukw13AYgnbtOpLxYq86-HX5tDQUq/view?usp=sharing
Thanks in advance
You just need to use the Date column from your Calendar table in your date slicer instead. The date table filter the other table but not the other way around. Slicing on the Period dates doesn't filter the Calendar table.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
1 Reply
- mahoneypat
Microsoft Employee
You just need to use the Date column from your Calendar table in your date slicer instead. The date table filter the other table but not the other way around. Slicing on the Period dates doesn't filter the Calendar table.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat