Forum Discussion
Custom Date Table slicer causing data to vanish
Hi, I've been building a report for a client and we need to create a central Calendar table which we can use for filtering purposes and for calculations. I've read up about this online and the pr...
HotChilli
Community Champion
Community ChampionThis looks like the date table has date/time values with 00:00:00 in the time section and the CreatedOn has various different time values so they won't match up. Hence relationship doesn't work properly.
--
Date table should have Date type fields. Fields on both sides of a relationship should be the same data type.
Have updated both to Date but looks to still be occurring: