dynamic slicer values

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. 

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-selection/m-p/3382998#M1125610

this might help you .

I hope I answered your question!