Forum Discussion
Auto filter for Visual based on Slicer selection
Hi, I have Slicer in my report, with following value defined: 12-2022 11-2022 10-2022 09-2022 08-2022 07-2022 06-2022 05-2022 04-2022 03-2022 02-2022 01-2022 This is the YearMonth...
sarikei , It can not select automatically.
You need to have independent table and slicer values need to be independent table
example
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -2) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI