I need to slice by dates which are not symmetrical, i.e. custom date ranges

[tommy_g]

I have a client request to provide a slicer for custom date ranges, which will then be sync'd across multiple report pages.

Effectively, they want shortcuts which replace the standard date slicer in "relative" mode.

Currently this is a hidden control and we set dates through use of bookmarks.

Unfortunately, independed buttons provide no visual cue as to which one is selected.

I'd like to use a horizontal slicer with the four options, similar to the following, just with each button setting a different date range as indicated above. Visual feedback is essential

I am guessing there would be a DAX routine with a Switch based on button value.

If that can be done, I'm still clueless on how I would set the hidden relative slicer, which works functionally and sync's well.

Looking for low-code / no-code ideas.

[amitchandak]

@tommy_g , Not very clear , refer

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

measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Using external tools

https://www.youtube.com/watch?v=vlnx7QUVYME

[mahoneypat]

This would be a good application of Calculation Groups using Tabular Editor.  You can make a Calculation Item for each time period, and then use that column in your slicer.

Introducing Calculation Groups - SQLBI

Regards,

Pat

[tommy_g]

Sounds like a viable plan. I will dig into it this weekend.

Am I to understand that whatever my calculation group produces, it will be attached to the slicer button pushed?