Forum Discussion

yashwant101's avatar
yashwant101
Icon for Helper III rankHelper III
3 years ago

Different 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 c...
Need Help
Show and Tell
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

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's avatar
    yashwant101
    Icon for Helper III rankHelper III
    3 years ago

    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's avatar
      eliasayyy
      Icon for Memorable Member rankMemorable Member
      3 years ago

      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's avatar
        yashwant101
        Icon for Helper III rankHelper III
        3 years ago

        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.