Dynamic slicer values

[Anonymous]

Hi All,

 I have a requirement to show dynamic date ranges as a slicer value which would depend on the selection from another slicer. Lets say I have below values in a table which I am using as a slicer 

Suppose if I select day in above slicer, the below date range slicer should show me all date values :

However if I choose "Week" then it should show me the range slicer only containing the week start datesm simmilaryly on choosing "Month" it should show range slicer only containing Month start dates. I tried to do this using a bridge/Intermediate table but power BI doesnt allow range slicers except for continuos dates and whole numbers. But in my case dates are not continous. 

Any help would be appreciated.

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may try the Timeline Slicer.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?src=office&tab=Overview

[Anonymous]

This is helpful but the slider is too long to be accomodated in the report. I was mostly looking for a dropdown kind of thing where it should show only the start dates of respective periods , more like how I have shown in the image.

[Anonymous]

Hi All,

 I have a requirement to show dynamic date ranges as a slicer value which would depend on the selection from another slicer. Lets say I have below values in a table which I am using as a slicer 

Suppose if I select day in above slicer, the below date range slicer should show me all date values :

However if I choose "Week" then it should show me the range slicer only containing the week start datesm simmilaryly on choosing "Month" it should show range slicer only containing Month start dates. I tried to do this using a bridge/Intermediate table but power BI doesnt allow range slicers except for continuos dates and whole numbers. But in my case dates are not continous. 

Any help would be appreciated.