Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

change date slicer range based on selection

Hi all,
I would like to update a date slicer depending on a category.

In the attached example, I have a table with ids, categories and start dates.
I also have a date slicer which by default hase a range equal to my calendar table.

 

I managed to create a measure (min_start_date_per_cat) which gives me the minimal date for each category.

I also managed to create a calendar tables which updates depending on the category selected.

 

However, i would like my date slicer to also update.

In the attached example, when I select the category B, the slicer goes from 01/01/2021 but I would like it to start from 01/06/2021

 

Any idea on how to achieve this?

the pbix is in the link below : 
https://www.transfernow.net/dl/20220112cvKiYJ8l 

1 Reply