Forum Discussion

deechappi's avatar
deechappi
Frequent Visitor
3 years ago
Solved

Filter the column(s) values based on the slicer

I have a dataset with 4 columns like the one below: Column1 Index Category ID 4908 1 A  123 4912 2 B 456 4915 3 C 789 4918 4 D 134 4922 5 E 178 4925 6 B 398 4928 7 F 549 4932 8 A 753 ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi deechappi ,

     

    Please create an unreleated DimColumn1 table for slicer. Then create a measure to have a test.

    Filter = 
    VAR _SELECTVALUE =
        SELECTEDVALUE ( 'Filter'[Column1] )
    VAR _VALUEBEFORE =
        CALCULATE (
            MAX ( 'Table'[Column1] ),
            FILTER ( ALL ( 'Table' ), 'Table'[Column1] < _SELECTVALUE )
        )
    RETURN
        IF ( MAX ( 'Table'[Column1] ) >= _VALUEBEFORE, 1, 0 )

    Add this filter into table visual and set it to show items when value = 1.

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.