default slicer selection for Current month

[Mani1205]

Team,

I have a table which contains date from Jan 2020 to Dec 2020 and i have created a slicer as below,  selected may month date manually ... but i want to select always current month minus 2 months as a default selection ... is it possible to do? pls help.

[amitchandak · Accepted solution]

@Mani1205 , Not possible to default slicer by function.

You can create a column like this and have the values selected

new column =

Switch( True(),

eomonth([Date],0) >= eomonth(Today(),-1),"Last to Last  Month" ,
eomonth([Date],0) >= eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0) >= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

new column =

Switch( True(),

eomonth([Date],0) >= eomonth(Today(),-1),"Data  Month" ,
Format([Date],"MMM-YYYY")
)

and select last to last month or data month and save the slicer value

[v-yiruan-msft · Accepted solution]

Hi @Mani1205 ，

You can refer the content in the following link as workaround to achieve it.

Power BI - How to Set a Default Slicer Value

Best Regards

Rena

[amitchandak · Accepted solution]

@Mani1205 , Not possible to default slicer by function.

You can create a column like this and have the values selected

new column =

Switch( True(),

eomonth([Date],0) >= eomonth(Today(),-1),"Last to Last  Month" ,
eomonth([Date],0) >= eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0) >= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

new column =

Switch( True(),

eomonth([Date],0) >= eomonth(Today(),-1),"Data  Month" ,
Format([Date],"MMM-YYYY")
)

and select last to last month or data month and save the slicer value