Forum Discussion
Calendar Issue
Hello:
I created calendar using 3 different ways on my report. I am able to build relationship between calendar table & source table date column.
I am using Slicer to filter data based on start date & end date using date from calendar table and that is where the problem begins. i am not seeing that data is filter by date & no data is returned by using date column from calendar table.
I want to know if anybody has encounter this kind of issue & what was the resolution.
Any help is greatly appreciated.
Thanks again.
Thanks
Jay
This was data type issue. I changed source table date column to DATE type & its working now.
Thank you all.
2 Replies
- AnonymousNot applicable
Difficult to provide the solution without seeing your data model and how the relationship is defined and how the filter direction set.
- aaditya2000Helper II
This was data type issue. I changed source table date column to DATE type & its working now.
Thank you all.