Dependant slicers are not updating when Apply Slicer button is using

[pavankch24]

Hi All,

I stuck with dependant slicers (Date period -- Date Range)

1. Date Period have Months as well as custom range. 

2. The "Date Range" slicer should automatically update when any date period is selected (month/custom range) as shown in the screenshot, but it is not updating when there is a apply button is used.  Below is the screenshot of the same.

If you see, the 2: the date range is disabled if I select any period from my 1st slicer. The "Date Range" is updating only when "Apply all slicers" button is clicked on, but the expectation is order, once the all the slicers are updated/selected then only "Apply all slicers" button should enable to view the report with all the changes (selected slicers). 

@sync slicers

Thanks in advance. 

[tharunkumarRTK]

@pavankch24 

"Date Range" column and "Date" Date columns are in the same date table? if yes then can you share your datetable implementation. 

I think your implementation is not appropriate, if you want to give custom range option as well as month slicer then follow this this approach

https://community.fabric.microsoft.com/t5/Desktop/date-range-selector-should-default-to-showing-a-ra...

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[pavankch24]

Hi Tharun,

Normally when I select any value from "Type" slicer the "Date Range" Date is updating...no issues, but only challenge is when the "Apply all slicers" button is added. Hope you got what I am talking about.

Thanks

[tharunkumarRTK · Accepted solution]

@pavankch24 

I understand, Please be informed "Apply all slicers" button will impact all the slicers in the report page and you cannot pick one or two

Please go through this doc 

https://learn.microsoft.com/en-us/power-bi/create-reports/buttons-apply-all-clear-all-slicers?tabs=p...

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!