Filter Table Visual Based on Slicer Selection

Anonymous — Fri, 30 Oct 2020 00:35:04 GMT

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!

Re: Filter Table Visual Based on Slicer Selection

amitchandak — Fri, 30 Oct 2020 03:05:07 GMT

Anonymous , Try a measure like

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

topic Re: Filter Table Visual Based on Slicer Selection in DAX Commands and Tips

Filter Table Visual Based on Slicer Selection

Re: Filter Table Visual Based on Slicer Selection