How to set default slicer value in Power BI

[@pracasrv]

Super Helpful. I've looked at 10+ tutorials on this - but none of it addressed it like you did. Great Job! Appreciate it.

[@thebihub]

Thanks Prakash!

[@kartikeyatiwari6678]

Hi can you make video for current logged user and orther user list ,, does this solution works for that too ?? kindly suggest. thnx

[@Lixia123]

This is what I am looking for, thanks a lot !

[@thebihub]

Glad it helped you , Thanks!☺

[@asgerlarsen2083]

Nice. Is there a way of keeping the name of the latest month instead of using "Latest Month" as the name?

[@thebihub]

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

[@3danim8r1]

Can we add this on the basis of Calendar table?

[@thebihub]

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

[@sridharm3571]

Great, helpful!

[@thebihub]

Thanks!

[@lakshminarayana3168]

I want to keep the default selection for the last 3 months, how can I achieve this ,can you help me 🙏

[@thebihub]

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)

[@izabelapereira1679]

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

[@thebihub]

@@izabelapereira1679 thanks!

[@PoojaYadav-jx9sl]

Suppose my data changes earlier I was having data till 2024 Jun and now I have data till 2023 dec then how it works , currently I am facing problem on this can someone help me

[@thebihub]

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

[@PoojaYadav-jx9sl]

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

[@PoojaYadav-jx9sl]

Can you tell me what logic do I need to use

[@PoojaYadav-jx9sl]

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

[@PoojaYadav-jx9sl]

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

[@kalyank2638]

Thanks but i. My reult mam seeing latest month and dec as well

[@kalyank2638]

Can u pls help

[@kalyank2638]

Can u pls help