Forum Discussion
Dynamic Month Slicer
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?
7 Replies
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 , 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")
)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.
Hi,
See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.
