dynamic slicer values

[ajinkyacgaikwad]

lets say we have a geography table having columns Area, region, country.

on tab1 i have 'area' slicer which is synced across all the tabs and on tab2 i have 'country' slicer.(forced selection) select one value.
I have 'India' set as default on tab2 and 'all' on tab1 for 'area'. when the user selects 'America' as area on tab1 and navigates to tab2 all the visuals on tab2 go blank until a country from 'america' is selected.

help me with this. so that when a value is selected in 'area' slicer on tab1 then automatically on tab2 the country should take countries from 'America'

[Anonymous · Accepted solution]

Hi @ajinkyacgaikwad ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We can create two pages and a page navigation button. Then we create an AREA slicer on page 1, select that slicer and click Synchronize Slicer to set up synchronization as shown below. Then we create a country slicer and visual object on page 2.

Best Regards,

Neeko Tang

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

[Uzi2019 · Accepted solution]

Hi @ajinkyacgaikwad 

There is nothing wrong with data and report. just because of single selection filter your slicer is on last state where you have put india by default. 

because your slicer would not understand to switch to the next value untill you manually change it.

Unfortunately, there is no option to keep all selected functionality with a single selection.

But still you can check this blog

https://community.fabric.microsoft.com/t5/Desktop/Change-slicer-settings-dynamically-to-single-selec...

this might help you .

I hope I answered your question!

[Anonymous · Accepted solution]

Hi @ajinkyacgaikwad ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We can create two pages and a page navigation button. Then we create an AREA slicer on page 1, select that slicer and click Synchronize Slicer to set up synchronization as shown below. Then we create a country slicer and visual object on page 2.

Best Regards,

Neeko Tang

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