Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Slicer Default Setting and configurations

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

Need Help
NOT

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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))

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.