Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
inakiachotegui
Frequent Visitor

Date and Hour filter not working

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:

inakiachotegui_0-1698939393615.png

Filtered not being applied correctly on the date & hour column data:

inakiachotegui_1-1698939434768.png

 

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: 

inakiachotegui_2-1698939509274.png

 

2 REPLIES 2
lbendlin
Super User
Super User

seems to work in import mode

lbendlin_0-1699115878556.png

also seems to work in Direct Query mode

lbendlin_1-1699116315991.png

 

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

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors