how to select multiple values as default in a slicer in power bi

[Mahmoodul]

Hi,

how to select multiple values as default in a slicer in power bi by using DAX,Can you please help me.Her

Here, in above image if you see i want to select FY2207 and HISTORICAL value by default usig DAX, when its refresh suppose FY2208 and HISTORICAL, its will autometically select these value.

[amitchandak]

@Mahmoodul , You need a new column

If ([FY Month] =max([FYMonth]) && [FY Month] = "HISTORICAL", "Current and HISTORICAL" , [FY Month])

Select Current and HISTORICAL and save,

As of now we can use measure of function to initialize that

[Mahmoodul]

Hi @amitchandak,

the above DAx give me both current and Historical both,This is correct result 

Here, if you see above image, FY2207 is my current value, When  we select "Current and HISTORICAL " its not give me desired result.