Forum Discussion
Syncing 2 slicers from same table
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?
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.
5 Replies
- Kaviraj11
Solution Sage
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' ) ) 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.
IrwanSuper User
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.
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 😉
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.
