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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
TheBIGuy_PBI
Helper II
Helper II

Date range filter - choosing start and end dates from a slicer

Hi, how would you filter a detail table, where a user chooses a start and end date from a drop down, and all you want to see are the records that fall within that range?

TheBIGuy_PBI_0-1680640700390.png

 

1 REPLY 1
vicky_
Super User
Super User

Create a measure like: 

ShowRecord = IF(Table2[Date] >= [StartTime] && Table2[Date] <= [EndTime], 1)

and then use that as a visual-level filter on the table.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors