Slicer 3/6/9/12 months for whole page

[lherbert501]

Hi,

Is it possible to create a custom slicer that has previous 3,6,9 and 12 months to end of previous month?

I know there is relative slicer but I want to lock it down and not allow other selections.

I can see some information online but they all seem to be aimed at one measure or visual. Is it possible to do this for a whole page with different measures?

Thanks

[Shubham_rai955 · Accepted solution]

Yes, you can create a custom slicer with fixed options like previous 3, 6, 9, and 12 months ending at the previous month, and apply it to the whole page across multiple measures.

How to do it:

1. Create a disconnected slicer table with the fixed period options (3, 6, 9, 12) months.

2. Use a DAX measure to calculate the filtering logic dynamically:

   • Calculate the max date as end of previous month.

   • Based on slicer selection, filter date range accordingly.

3. Modify all measures to use this dynamic filter measure instead of direct date filters.

4. Place the slicer on the page (single slicer, no relative date slicer).

5. The slicer controls filtering for all visuals/measures via the dynamic DAX logic, locking it to fixed options only.

This locks down selection options and makes the same period slicer affect the entire page consistently across different measures and visuals.

If you want, the slicer visual can also be set to single-select to further enforce only one selection at a time.

This approach overrides default relative slicer flexibility and works at the page level.

[parry2k · Accepted solution]

@lherbert501 use scalable approach from this post  and from there, everything will be super easy to control. Make the changes to this approach as per your needs.

[Shubham_rai955 · Accepted solution]

Yes, you can create a custom slicer with fixed options like previous 3, 6, 9, and 12 months ending at the previous month, and apply it to the whole page across multiple measures.

How to do it:

1. Create a disconnected slicer table with the fixed period options (3, 6, 9, 12) months.

2. Use a DAX measure to calculate the filtering logic dynamically:

   • Calculate the max date as end of previous month.

   • Based on slicer selection, filter date range accordingly.

3. Modify all measures to use this dynamic filter measure instead of direct date filters.

4. Place the slicer on the page (single slicer, no relative date slicer).

5. The slicer controls filtering for all visuals/measures via the dynamic DAX logic, locking it to fixed options only.

This locks down selection options and makes the same period slicer affect the entire page consistently across different measures and visuals.

If you want, the slicer visual can also be set to single-select to further enforce only one selection at a time.

This approach overrides default relative slicer flexibility and works at the page level.