Last 3 / 6 / 12 Months Slicer

[RENJITH_R_S]

Friends

I have a required like a I need a slicer with 3 values
last 12 months
last 6 months

last 3 months

My sample data set is like

Date                latest date

Apr 2021         Apr 2021

Mar 2021        Apr 2021

Feb 2021         Apr 2021

Jan 2021        Apr 2021

Dec 2020         Apr 2021

Nov 2020        Apr 2021

Oct 2020         Apr 2021

Sep 2020        Apr 2021

Aug 2020         Apr 2021

Jul 2020        Apr 2021

Jun 2020         Apr 2021

May 2020        Apr 2021

if user selects last 3 months in slicer table to needs to show like

Date                latest date

Mar 2021        Apr 2021

Feb 2021         Apr 2021

Jan 2021        Apr 2021

if user selects last 6 months in slicer table to needs to show like

Date                latest date

Mar 2021        Apr 2021

Feb 2021         Apr 2021

Jan 2021        Apr 2021

Nov 2020        Apr 2021

Oct 2020         Apr 2021

Sep 2020        Apr 2021

like 12 also

Is it possible please help on this

[amitchandak · Accepted solution]

@RENJITH_R_S , refer to this video, I discussed the similar stuff - https://youtu.be/44fGGmg9fHI

or

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-3...

[RENJITH_R_S]

@amitchandak Thanks