Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 58 | |
| 53 | |
| 43 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 122 | |
| 108 | |
| 44 | |
| 32 | |
| 24 |