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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have a report using direct query which includes multiple tables with date columns in it, all of them being filtered correctly excluding the one that includes date & hour. Whenever I filter a table using the Filters panel I'm able to limit the dates shown on any of the date columns excluding this one.
When I tried to apply a filter to show an specific date it goes to blank.
Examples ahead.
Regultar date column being filtered correctly with the filters panel:
Filtered not being applied correctly on the date & hour column data:
I assume this is a really obvious mistake but I can´t seem to find the solution.
This is the value configuration in the realtions view:
seems to work in import mode
also seems to work in Direct Query mode
Might be something to do with your data model, especially if you have a calendar table.
Yes, I´m aware of how it's supposed to be working cause I already did it on dummy versions and the import mode. I was asking for any out of the box solutions since I can´t seem to find any working solution or similar case. I'm not using a calendar table, just a date column imported from sql