Max year should be display in Slicer when user open Power BI pbix file first time.

[Anonymous]

Hi ,

I am having 2 slicer in Report First is for Year and Second Slicer is for Month Name 

First Slicer  like below data         

2014                                                     

2015 

2016

Second Slicer having data like below 

January 

February

March 

April 

Here requirement is when user open pbix file that report should display Max Year and Max Month by default in both slicer visual. 

How to handled that using DAX. Please guide me  because in normal Slicer there no any such property to set default Max Year or Max Month

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may deal with it in a similar way as described in link below.

https://community.powerbi.com/t5/Desktop/Default-Behavior-Date-Filter-to-Most-Recent/td-p/235337