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.
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.