Syncing a Date Hierarchy Drop-down slicer with a Date Slicer by day

[nbs33]

Hi,

I am trying to build a date slicer that allows the user to select a date range using a date hierarchy Year, Quarter, and Month but also give them the options to select a specific date range. At the moment I have two date slicers one for the hierarchy described above and one to select the date range by day.

How can I get these two to sync when the other is selected?  I have tried sync slicers and their interacrtions are set to filter eachother but I haven't had any luck.  Any help is greatly appreciated. 

Hierarchy Slicer

Slicer by Date range

[TheoC]

Hi @nbs33 

Are the Date fields you are using for the slicers the identical fields?  For example, are you using the Table[Date] in both the Hierarchy Slicer and the Slicer by Date Range?  Or are you using two different fields for each (i.e. Table[Date] and Date[Date])?  If you are using the latter, you need to ensure you have a one to many relationship from Date[Date] to Table[Date].

Look forward to hearing from you.

Theo

[nbs33]

Hi, thank you for the response. I am using the same date table for both. The date hierarchy is definded as 'Dates'[Year],'Dates'[Quarter],'Dates'[Month], and 'Dates'[Date] in this order, while the other slicer is just 'Dates'[Date]. 

[Anonymous · Accepted solution]

Hi @nbs33 

Select Hierarchy Drop-down slicer, and try "Edit Interaction" function in Format. Select Filter icon in your range date slicer. 

For reference: Change how visuals interact in a Power BI report

Then you can filter it by Hierarchy Drop-down slicer. 

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.