Reg:Default selection of slicer value(MAX DATE)

[gladies123]

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

THANKS,

GLADIS

[v-yangliu-msft]

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])
return
IF(
    '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

[halfglassdarkly]

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

=switch(true(),

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

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

"Current")

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.