Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
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.
Dates in my sales table are like first of every month but not other dates.
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |