Different Values Sync Slicers

[yashwant101]

Hi team,

I have implemented sync slicers in my report for ilter passing through pages. However there is a requirement where I need to hide a few values in one of those slicers.

Say I have 4 countried- India, USA, England and Spain.If I have 5 pages in the report, slisers in 4 pages the slicer need to contain all the 4 countries names but in one of them the slicer should contain only India and Spain. 

Now if the users are on other pages and have selected either India or Spain in the country slicer filter passing should work as expected when moved to the last page. But if they have selected USA or England then when moving to the last page the country slicer should default to India. 

Please let me know if there is a way we can achieve this through or any other workarouand to achieve filter passing and less values in last page.

[mussaenda]

Hi @yashwant101 ,

Would it be better not to sync the filter to the last page and let them select what they need on your last page?

[eliasayyy]

hello @yashwant101  as you said ,you are using sync slicer , so all slicers act as one slicer , so in theory you cannot filter on slicer or all will get affected

[yashwant101]

Hi @eliasayyy, thanks for your response. Is there any other work around to get filter pasing alongwith lesser values in slicer on one page?

[eliasayyy]

if you want less values in a filter , you could try creating  measure 

if( max('table'[slicer column]) IN {"India" , "Spain" } ,1 , 0 )

this should return 1 for india and spain and 0 for the rest then just insert the measure in the filter panel of the slicer and put it to " is" 1

[yashwant101]

Hi @eliasayyy , but as I mentioned earlier I want the slicer value to be restricted on only 1 page. If I apply filter on the slicer, it will apply on all pages.

[eliasayyy]

then tr the same measure and formtat but instead on the slicer , put it on the filter this page part