How to get data of last n periods on basis of filter

[ankit2747]

Hello All,

Can someone help me on below scenario;

I have 2 columns "Date" and "Amount" and a filter on "Date".

I want to filter data in my visual for last "N" months on basis of date selected in "Date" filter.

Any input is highly appreciated. Thanks!

[v-piga-msft]

Hi @ankit2747,

As pattemmanohar mentioned, you could use visual level filter like below.

If you still need help, please describe your scenario in more details.

Best  Regards,

Cherry

[ankit2747]

Hello,

Thanks for your response.

The solution you suggested filters data according to today's date. But in my scenario, I need that if I select a date in Slicer , the data gets filtered for say last 12 months from the date selected in slicer.

[v-piga-msft · Accepted solution]

Hi @ankit2747,

For your scenario, I think you should create a measure to show the amount dynamiclly based on your selectvalue in the slicer.

Here is a sample which should be similar to your scenario. You could have a good look at it.

Best  Regards,

Cherry

[PattemManohar]

@ankit2747 Please try using "Visual Level Filters" option