Making a slicer or graph display X months back

[pantherfanrh]

Hi all!

I am trying to use Power BI to display a report that will show me the past X number of months from the point that I click. For instance, If I click Jan, 2016 in the slicer, it will display September 2015-Jan 2016 in the graph (or however many months back X is). I understand you can use drill down to display by the years, but that is not what I want it to do (as drill down will only show me the months in that year.) I tried using the timeline slicer, and that didn't help. Any help would be appreciated!

Thanks again!

[Greg_Deckler]

Could you create a measure that did the calculation of X back so that numbers would be like 1 for 1 month back, 2 for two months back, etc. and then just set your filter on your visual to be that measure < X months back?

[pantherfanrh]

So something like

date=EDATE([workdate],13)

then set the filter to that measure?

I'm trying to use EDATE but it doesn't like it when I use my column of dates in the table. Any advice?

[Anonymous · Accepted solution]

Hi @pantherfanrh,

I'd like to suggest you add a calculate column to show the diff between current row and today. After create the column, you can  use this as the source of slicer(switch the mode to "Less than or equal to")

Calculated column formula:

Diff = DATEDIFF([Date],TODAY(),MONTH) 

Notice: you should turn on the preview feature "number range slicer" to enable the expand options.

Regards,

Xiaoxin Sheng

[pantherfanrh]

Thank you so much!