Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter Table Visual Based on Slicer Selection

Hello,

 

I have a table visual  on my report that is composed of columns from four different tables. One of my slicers is choosing from a list of dates, in the format YYMM, in whole number datatype. I am trying to filter the table visual to include only the rows associated with the YYMM that is less than or equal to the one selected, preferable using a measure.

 

Any help is appreciated!

 

 

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try a measure like

    measure =
    var _max =maxx(allselected(Date), Date[YYMM])
    return
    calculate([measure],filter(all(Date),Date[YYMM]<=_max))