cancel
Showing results for 
Search instead for 
Did you mean: 
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
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors