cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AshDil
Helper V
Helper V

Max Date in Slicer

Hi,

 

In slicer, the date should be seleted to Max date by default whenever report is opened and also allow user to select the date of interest.

Eg: In the following slicer, Max date = 08/02/2022 

AshDil_0-1660120472607.png

Whenever user opened the report, the max date must be selected by default

AshDil_2-1660120752488.png

Then if user want to see any different date data, then can able to select that date.

Please help me to do it.

Thanks,

AshDil.

 

1 REPLY 1
NickolajJessen
Super User
Super User

I am not aware of any self selecting capabilities of slicers. I'm not sure about the size of your report, but if you have a reasonable amount of measure, you can adjust them to show the data for the latest date, unless another date is selected from the slicer. Goes someting like this.

 

Measure =
If( HasoneValue(Calendar[Date]),
   YourMeasureHere, //If selection is made, calculate the calue
   Calcualte( YourMeasureHere, filter(calendar, Calendar[Date] = Today()) ) // If no selection is made, use todays date by default (or use max date of your dataset, if that is more appropriate)

 



Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.