Forum Discussion

HRawash1's avatar
HRawash1
New Member
3 years ago
Solved

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..

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

 

Many thanks!

  • tamerj1's avatar
    tamerj1
    3 years ago

    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] ) ) )

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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] ) ) )