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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
HRawash1
New Member

Filtering Time will select all previous Time

Hi, I have a question relating to filters. How can I setup a filter that when you select time value it will also select all the previous values in the table?

 

Here is a sample data table..

table.png

Is there a way to achieve this with a measure or a filter setting?

 

Many thanks!

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @HRawash1 

you may create a disconnected time table that will be used in the slicer

TimeTable =
SELECTCOLUMNS (
GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 45, 0 ), TIME ( 0, 15, 0 ) ),
"Time", [Value]
)
then place the following measure in the filter pane of the table visual, select "is not blank" then apply the filter 

FilterMeasure =
COUNTROWS ( FILTER ( 'Table', 'Table'[Intervsks] <= MAX ( TimeTable[Time] ) ) )

View solution in original post

2 REPLIES 2
HRawash1
New Member

thank you so much solved 

tamerj1
Super User
Super User

Hi @HRawash1 

you may create a disconnected time table that will be used in the slicer

TimeTable =
SELECTCOLUMNS (
GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 45, 0 ), TIME ( 0, 15, 0 ) ),
"Time", [Value]
)
then place the following measure in the filter pane of the table visual, select "is not blank" then apply the filter 

FilterMeasure =
COUNTROWS ( FILTER ( 'Table', 'Table'[Intervsks] <= MAX ( TimeTable[Time] ) ) )

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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