Latest date in slicer by Default

[Anonymous]

Hi All,

I planned to keep Year,Month,Day in slicer and in that slicer i want the latest values should be selected.

For eg. if i take Year Slicer then 2020 should be in selected mode. and if user changes it to 2019,2018 in slicer then the charts should show respective data. For eg. if today is 1st Jan 2021 then slicer should automatically change to 2021 when we open the report.

Same for month for today it should open in by default as July(Since today is july 31). If we opens it tomorrow(Aug 1)then  slicer should show Aug.

Same for Day. Max Date should be already selected when i open the power bi report.

Regards,

Prakash M

[Anonymous]

@Anonymous 

As far as I know, it is not possible to make the slicer select the latest option by default based on your selected time period. You can only create measures that returns the latest time periods. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , In your date table, create a column like this and select This year

Year Type = Switch( True(),
year([Date]) = year(Today())-1,"Last Year" ,
year([Date])= year(Today()),"This Year" ,
Format([Date],"YYYY")
)

[Anonymous]

Hi @amitchandak ,

Thanks for your reply.

But in Year Slicer i am expecting 2020,2019,2018....etc values.

So you are saying to create additional column and need to give that as slicer? But instead of "This Year" I would like that to populate as 2020.

Since we have limited values for Year but how to do that for Month and Day? We will have so many values for Day and Months.

Is that possible?

Regards,

Prakash M