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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.