Dynamic "last 12 calendar months" including current month default slicer selection

[CRamirez]

Question is largely in the title, but I'm looking for a way to have the last 12 - 13 months as a default slicer selection for my users. This is not accomplished through relative date filtering as I do not know of a way to simultaneously have "Last 12 Months (Calendar)" OR "This Month" in the same selection.

For example, ideally today (3/17/2020) the slicer would display 3/1/2019 - 3/16/2020, which could then be manipulated by users if they need.

This is also not possible through the "Between" option on a date slicer as the defaulted beginning and ending points are not dynamic which leads to the default filter eventually being months in the past everytime a user opens the report.

I also do not want this to be forced into a measure through time intelligence as I want my users to be able to select varying timeframes on their own (for instance if they wanted to look at the last 3 months instead). Everything I've found so far in my research has "hard-coded" a specific timeframe within it.

Is there any possible way in Power BI currently to meet this need? It seems like quite a basic feature and I know it's possible in SSRS, but I'm having no luck trying to accomplish this in Power BI.

[v-deddai1-msft · Accepted solution]

Hi @CRamirez ,

You can create a calculated table for the slicer to show all dates from the past year to yesterday:

Table = CALENDAR(date(YEAR(TODAY())-1,MONTH(TODAY()), 1),TODAY()-1)

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

Best Regards,

Dedmon Dai