Forum Discussion
Different Values Sync Slicers
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
Hi eliasayyy, thanks for your response. Is there any other work around to get filter pasing alongwith lesser values in slicer on one page?
- eliasayyy3 years ago
Memorable Member
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- yashwant1013 years ago
Helper III
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.
- eliasayyy3 years ago
Memorable Member
then tr the same measure and formtat but instead on the slicer , put it on the filter this page part