select largest value automatically slicer

If you are using a dropdown/tile/list slicer to select your date you can do the following:

• Go to the right-hand Data pane and click the "..." (More Options) of the database containing your date values
• Create a "New Column"
• Enter the following formula for the new column:

Date_Slicer = if([NameOfYourDateColumn] = MAX([NameOfYourDateColumn]), "Latest Month", FORMAT([NameOfYourDateColumn], "MM-YYYY"))

• Select the "Table view" on the left-hand side, select the "Column tools" tab and select your original date column in "Sort by column":

• Instead of the date column, use this new column for your slicer
• Ensure that "Latest Month" is selected before publishing:

As you can see this is written for a date column as a source, but it should also work for other value types (just leave out the FORMAT part then).