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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
icassiem
Post Patron
Post Patron

Date Picker Custom Dates and Date Slicer does not overrid custom selection without a reset/clear btn

Good day,

 

Last month, i battled to have a Range Slicer control the datepicker Slicer,

Range slcier would filter the date picker Slicer but date picker custom dates was within the boundaries of the Range Slicer filtered dates only, okay when Range = YTD but not okay day/week/month.

1. Basically the Range slicer was to only default the selection but still allowing the date picker to override the selection

2. Range Sclicer has a custom range and when date picker selects dates the other range options (ytd/month/day) will not work/override the custom date picker selections.

 

I never found a work around as i cant have a clear slicer button using bookmarks etc, senior says it makes the scorecard less practical as i have a date picker per KPI

 

Please any ideas, links

 

Regards 

4 REPLIES 4
icassiem
Post Patron
Post Patron

Hi,

Any ideas please on defaulting the date picker without hard filtering?

Regards

v-zhouwen-msft
Community Support
Community Support

Hi @icassiem ,

Regarding your question, you can control the influence between the slicers by editing the interactions, select any previous article and click on 'Format' to find the interaction options, with reasonable settings you can realize the range slicer as the default selection, the date selection slicer is still free to select the date.
Change how visuals interact in a report - Power BI | Microsoft Learn

Hi,

Apologies for the late reply, Thank You @v-zhouwen-msft 

 

1. the range slicer filters both slicers, should i disable the picker slicer interaction with range slicer

but when i do, the range slicer does not overide the picker slicer value?

 

2. When range slicer filters /interaction the picker slicer, the dates available for custom selection are limited to the range slicer selection, it should only soft default the selection but still able to change the dates range

it only works when the range picker has a long range ytd but when month/day/week then its limited

 

please advise?

Hi,

 

Please any help, where my DateRangeSlicer only defaults the selection within DatePickerSlicer but Allows for DatePickerSlicer to custom select dates outside of the default selected specified by DateRangeSlicer

I have a timeseries with custom, but senior does not want the custom button to be selected to enable custom date ranges and that the butoon slicers should be able to be overwritten by date picker custom selection

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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