Use SWITCH to create a dynamic slicer for dimension values

[AdamRobC]

Hi,

I currently have various dynamic time period columns set up in my date table using DAX and based on the TODAY() function (e.g. if relative week = -1 then "Last Week" etc.)

I would like to use the SWITCH function to have one slicer where the user can flip between various 'fixed' time periods, which dynamically updates charts to show data for that time period.

At the moment I have the below set up in 3 separate slicers, which works ok but would be better to have everything in one slicer if possible.

Thanks,

Adam

[V-lianl-msft]

Hi @AdamRobC ,

Based on your description, I can't know what kind of results you want. It needs to be clarified that the calculated columns cannot be dynamic and will be recalculated every time they are refreshed. Measure cannot be used as a slicer, it can be used as a slicer's visual level filter.So what kind of results do you expect?

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

[amitchandak]

@AdamRobC , Not very clear. But try like

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