Slicer Default Setting and configurations

[Anonymous]

Hello Experts,

Please can you share the DAX commands or other ways where I can set my filters to default value. 

Requirement: Default last 3 year financial years have to be displayed from current date. I have a slicer with Hierarchy and able to display Year, Quarter and month 

2. I have to set default to all the filters I have .. 

3. I have attached a picture, when I sort the Financial Year are sorting not just the quarters in this. Any help

[Anonymous]

I created the first filter and I am not able to select as well. Probably I need help. My dates are hierarchical with Financial years.  2. I also need to configure 3 default divisions in division slicer .. almost all my slicers come with default settings 😞 any help is appreciated.

[amitchandak]

@Anonymous , If no date is selected

//Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date),Date[Date]) //
var _min = eomonth(_max, -36) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

//Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date),Date[Date]) //

var _maxy = maxx(allselected(Date),Date[year])
var _min = minx(filter(all('Date'), Date[year] = _maxy -3),Date[Date])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

If date is selected, then you need independent table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -36) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))