Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
This was data type issue. I changed source table date column to DATE type & its working now.
Thank you all.
Difficult to provide the solution without seeing your data model and how the relationship is defined and how the filter direction set.
This was data type issue. I changed source table date column to DATE type & its working now.
Thank you all.