Forum Discussion
Advocate ISlicer based on date and hour
Microsoft EmployeeI think you went about it correctly. The only reason why the realtionship wouldn't be working is if the Pen and notebook datetimes aren't aggregated to the hour. Meaning 2019-03-19 04:53:26 needs to be 2019-03-19 04:00:00. You have this in your example, but i wanted to be sure.
The default slicer doesn't support the hourly level, but i think there are custom slicers in the store that accomplish this.
A workaround would be creating a new calc column on each table that is a type of Number (preffered) or Text, with the formula being MyDateYMDH = FORMAT([MyDate], "yyyyMMddhh"), then relate them. However, this only solves the relationship problem, not the slicer problem.
Advocate IThanks so much for reply! Which slicer would be more appropriate from the store? The slicer i am using cannot select hours so scorecards display (Blank). I have tried others but was not able to find one that works.