Forum Discussion
Helper IIIDifferent Values Sync Slicers
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.
6 Replies
eliasayyyMemorable Member
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
yashwant101Hi 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
- mussaenda
Community Champion
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?
