Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |