Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Reg:Default selection of slicer value(MAX DATE)

Hi team,

I have created calendar table as calendar(min(date_refresh),max(date_refresh) date_refresh is a column which is located in my another table called business.Kindly provide solution to make default selection of max date in slicer , if my data is updated till 12-9-2021 so default selection has to be 12/9/2021 in slicer  then if my data is updated till 13-9-2021 so default selection has to be 13/9/2021 in slicer and it should be displayed all dates in slicer  but it should make a default selection max date




Community Support
Community Support

Hi  @gladies123 ,

This function power bi can’t be realized for the time being, you can try it: change the label of the maximum date to "Maxdate" and place it on the top of the slicer for better identification.

I created some data:

Table1: 2021.1.1 – 2021.3.1


Calendar table: CALENDAR(MIN('Table'[date]),MAX('Table'[date]))


Here are the steps you can follow:

1. Create calculated column.

Column =
var _max=MAXX(ALL('Calendar table'),'Calendar table'[Date])
    'Calendar table'[Date]=_max,"Maxdate",FORMAT('Calendar table'[Date],"yyyy/mm/dd"))

2. Place [Column] in the slicer and set Sort descending.


3. Result:

Will change the maximum date to "Maxdate" and stay at the top of the slicer:


Add a row of dates in the Table: 2021.4.1

Then 2021.4.1 becomes "Maxdate" and stays at the top of the slicer



Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Resolver I
Resolver I

It's a bit of a hack, but if you have a date dimension you could create a column that checks for the current/max data date and groups every other date under 'future' or 'previous' so eg



[Date] > Today(), "Future",

[Date] < Today(), "Past",



Then add that to your slicer before the date column to form a hierarchy in the slicer. That way you could save the file with the 'Current' parent ticked, which would include only the current date which should update dynamically.


Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors