Forum Discussion

jsevillaiv's avatar
jsevillaiv
Frequent Visitor
3 years ago

Filter table by multiple values from 1 slicer selection

I have these Wave values as my Slicer:


My goal is if I choose Wave 68, it should filter my Values table with all records based on the selected Wave (68) and the 3 previous Wave (65-67):

 


More example:

 


Thanks in advance!

Need Help

1 Reply

  • DataVitalizer's avatar
    DataVitalizer
    Super User
    3 years ago

    Hi jsevillaiv x

    1. Create a new table to use it as a slicer

    SlicerTable = DISTINCT('OriginalTable'[Wave])

    2. In your original Table create a new measure 

    RightValues=
    VAR SelectedWave = SELECTEDVALUE('SlicerTable'[Wave])
    VAR FilteredTable =
        FILTER(
            'OriginalTable',
            'OriginalTable'[Wave] >= SelectedWave - 3 &&
            'OriginalTable'[Wave] <= SelectedWave
        )
    RETURN
      MAXX(FilteredTable, 'OriginalTable'[Values])

    3. Add a new slicer with the Wave column from the SlicerTable
    4. Add Wave and RightValues into a a visual Table

     

    Apply it and let me know 👍

    Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
    Was this exchange helping? A kudos 👍 would be appreciated