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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors