Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
pavankch24
Frequent Visitor

Dependant slicers are not updating when Apply Slicer button is using

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.

 

pavankch24_0-1728129722998.png

 

 

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. 

3 REPLIES 3
tharunkumarRTK
Super User
Super User

@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!


PBI_SuperUser_Rank@2x.png

 

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

@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

Screenshot 2024-10-06 at 7.20.26 PM.png

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!


PBI_SuperUser_Rank@2x.png

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.