How to set default slicer value in Power BI 

Hi Pooja, the same solution given above will work, for the Max date month always it'll hold 'latest month'. In your case first time latest month would be jun 2024 now it'll be 2023 dec

I have a date table and a fact and they are connected to each in your case you are having only one table

Can you tell me what logic do I need to use

Date 2 = VAR _max_date = MAX ( 'Balance date'[Balance date] ) VAR _last_three_month = EOMONTH ( _max_date, -1 ) + 1 RETURN IF ( 'Balance date'[Balance date] >= _last_three_month, "current month", FORMAT ( 'Balance date'[Balance date], "yyyy mmm" ) ) this is the dax that I have written

It is giving me correct results in the calculated column but not in the slicer

Thanks Prakash!

Thanks!

Thanks, the same name is what making the slicer to keep on default, you can add a measure in the card (lookup value which I showed in the demo) as a note around the slicer if you want

Hi Lakshmi, to make top 3 months as Default selection add the calculated column, Top 3 months = IF(RANKX(ALL('TableName'[YYYYMM]),'TableName'[YYYYMM],,DESC)

@@thebihub Thanks for this one! It worked perfectly here.

@@izabelapereira1679 thanks!

Yes, Simply check for Maximum month (date ) from calendar table and make it as latest month as shown in video

Glad it helped you , Thanks!☺

Can u pls help

Can u pls help