Syncing 2 slicers from same table

[ANJ]

I've searched and didn't see anything specifically related to this.  Maybe it's not possible.

I have a calendar/dimension table:

Date	FYear	FWeek	FPeriod
01/09/2023	2024	1	1
02/09/2023	2024	1	1
08/09/2023	2024	2	1
01/01/2024	2024	13	3

The real table contains a row for each date and it's respective financial year/weel/period according to our sales team.

This is used all over our systems and reports and works well.

A request has come in to be able to have a date & week slicer.  This is easy enough add one for "Date" and one for "FWeek".  Of course by default they combine with each other.  If I set the date to be on or after "01/01/2024" and the week as 1 nothing is shown.

Is it possible to get the slicers to sync s that they reflect each other?  So if I set the date to on or after "01/01/2024" the week would auto-adjust to on or after 13.

Adding them to a group kind of works in that wich ever one you last adjust is what the data is filtered by, but visually they do not adjust.

Is there a way to get them to visually sync?

[ANJ]

@Kaviraj11 

Thanks.  I couldn't see a difference with that.

The slicers are both for the same table (Dimenson_Date) and both slicers need to have the same range, but it would be nice if they visually showed the same thing.

So, if I filter to just fin. year 2024.

The date slicer should have a range of:

03/10/2024 - 30/09/2024

The week slicer should have a range of:

1 - 52

If I set the date slicer to 16/04/2022 - 22/04/2024, it would be nice if the week slicer shows 29 - 29:

Where as at the moment it's showing 1-52 still.

[Irwan · Accepted solution]

hello @ANJ 

i think you can just enable those slicer interaction.

you see, by default when creating multiple slicer, their interaction was disable.

so here is the example,

when i set in index slicer 7 to 8, the value in API is 111 to 149.

when i enable their interaction, index slicer still 7 to 8, but API slicer show 111 to 121.

the maximum value in slicer is changed from 149 to 121.

and you need to re-enable their interaction each other. First slicer to second slicer and vice versa or else the value wont change to slicer with disable interaction.

Hope this will help.

Thank you.

[ANJ]

@Irwan 

Thanks that's the closest to what I wanted.  I hadn't even clocked that the slicer interation thing was across slicers as well, I had assumed just other visuals.  I need to remember that a slicer is also a visual 😉

@Kaviraj11 

Thanks for your help as well.  Although not really a solution for this, I didn't know you could filter slicers in this way, this will be good knowledge going forward.

This is our first foray into Power BI and it's a learning curve, esp. as we've dived in at the deep and have started with our biggest most complicated sales report - not my decision.

Thanks both for your help.  Most appreciated.

[Irwan]

hello @ANJ 

glad to be a help.

thank you.

[Kaviraj11]

Hi,

You can create a measure and put the measure in filter pane and set it to 1. It will only display the values that are available.

SlicerFilter = INT ( NOT ISEMPTY ( 'Your dataset' ) )