Forum Discussion
Syncing 2 slicers from same table
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. 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.