Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!