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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kvernon
Frequent Visitor

Date Range Slicer not filtering dates in direct query tables

I am very new to Power BI so I'm not sure if there is a simpler way to accomplish my use case.

 

I have multiple tables where an inspector will input data into at a particular date and time. These tables are in SQL Server.

I added two of these tables to the report as such:

kvernon_1-1661795225609.png

What I want is that the "Date" columns in these tables be filtered by it's date. So I basically want all instances of '01/04/2022' to be shown regardless of time. I was trying to use the date slicer pictured, I created a table of dates in SQL Server and also used a direct query to include the table in Power BI:

kvernon_2-1661795347932.png

The time for each day in this table is at midnight. I added the relationships but whenever I try to filter by the dates using the slicer the tables appear empty. 

kvernon_3-1661795499372.png

By the filter condition pictured I should be able to see all my data that is in April.

 

So how can I fix this? What am I doing wrong?

 

1 ACCEPTED SOLUTION

Hi @kvernon 

Please open Power Query editor and change the Date format to Date only (not datetime) for both table
If you need to keep DateTime for your data table, please create another column for Date only and use this column for relationship
01.png

 

Find the attached pbix

 

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

 

http://www.myaccountingtricks.com




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





View solution in original post

8 REPLIES 8
ReneMoawad
Resolver III
Resolver III

Try to create a column with just the Date without the time, and put this column in the slicer

It would have been nice if PowerBI just had a control where I can use to filter date and time normally but what I'll do is add a column with just date. Thank you

PijushRoy
Super User
Super User

@kvernon 

Please check the Datatype and Dateformat among Calender Table and your data table
DateTime or Date
DD/MM/YYYY or MM/DD/YYYY

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Here is the properties view on the model for the calendar table:

kvernon_1-1661801417125.png

 

And here in one of the data table:

kvernon_2-1661801439921.png

 

I should note that the Data table would have date and times such as 01/04/2022 09:45:06 and all the dates in the Calendar table are at midnight. I don't know if that would have anything to do with it?

@kvernon 

Can you please share pbix with non sensetive sample data (10 rows suffient)




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Ok here I made a sample report using Excel. U can download from this link:

SampleReport

Hi @kvernon 

Please open Power Query editor and change the Date format to Date only (not datetime) for both table
If you need to keep DateTime for your data table, please create another column for Date only and use this column for relationship
01.png

 

Find the attached pbix

 

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

 

http://www.myaccountingtricks.com




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





So what I'll do is add a date column in the data table, the items in that table is added by a completely different application so I have to work thru that system which added some complexity but I managed to get it to work. I would like it if Power BI just had a control to handle filtering between dates so I didn't have to make my tables so cumbersome but it is what it is. Thank you for your help!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.