Last 12M/6M/3M slicer to filter the table visual

[MandoPavs008]

Hi,

Can anyone help me with how to create a slicer with Last 12M/6M/3M to filter the table visual which has columns like Rank based on the products sold and other columns like below. Currently i can filter by Month_Year slicer but i wanted to change the slicer to Last12M/6M/3M 

Category	Rank	A%	Products sold	Impact
A	1	16.20%	19	15.70%
B	2	2.81%	27	2.23%
C	3	11.06%	69	1.62%
D	4	0.46%	3	1.05%
E	5	0.69%	42	0.88%
F	6	16.20%	19	0.88%
G	7	5.02%	109	0.75%
H	8	3.80%	47	0.75%
I	9	1.93%	47	0.74%
J	10	1.80%	46	0.72%

Thank you.

[MandoPavs008]

Thank you for your help. But I can't fix the months to 12M/6M/3M with the slicer you mentioned and also i dont want to add Date in my table visual. I wanted to add a slicer with just 12M/6M/3M to filter a table visual with the data without date which i have given in my initial post. 

[v-weiyan1-msft]

Hi @MandoPavs008 ,

I am not sure if I understood your question correctly.
Based on your description, it seems that you want to use the slicer to filter the data for the last 12 months, the last 6 months, etc.
Below is the data I created from the sample you provided.

You might consider creating a relative date slicer to suit your needs.
Please select the your slicer, and in the Format pane, under Visual > Slicer settings > Options, change the Style to Relative Date.

Result is as below.

For more you may refer to:

Create a relative date slicer or filter in Power BI - Power BI | Microsoft Learn
Please correct me if I misunderstood your needs.

Best Regards,
Yulia Yan

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

[MandoPavs008]

Dates in my sales table are like first of every month but not other dates.