Dynamic Month Slicer

[Anonymous]

Hi,

I want to select  dynamically last 4 month .It should select last 4 months and unselect other months dynmically.Month is coming from calendar table.Any idea how to do this?

[Ashish_Mathur]

Hi,

See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.

[v-alq-msft]

Hi, @Anonymous 

It is unsupported to set default values for a slicer. You may control the selectable values by slicers or filters. While you are unable to control selected value with them. I'd like to suggest you vote on the idea and add your comments there to improve Power BI for making this feature coming sooner.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , There no way unless you try a slicer like that and use that for selection

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

or

Month Type = Switch( True(),
eomonth([Date],0) >= eomonth(Today(),-3) && eomonth([Date],0) <= eomonth(Today(),0),"Last 4 Month" ,
Format([Date],"MMM-YYYY")
)

[Anonymous]

@Anonymous - Usre Relative Date Slicer, 

Appreciate your kudos!! Mark this post as solution if this helps.

[Anonymous]

I have used relative filter, but its only showing last 4 month .

I want  last 4 months should selected and other months show unselected.

[Anonymous]

@Anonymous - Have you considered using timeline slicer - https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?src=office

Appreciate your kudos!! Mark this post as solution if this helps.

[Anonymous]

One doubt , when Novemeber month will come then timeline slicer automatically select last four months?