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
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.

    • eliasayyy's avatar
      eliasayyy
      Icon for Memorable Member rankMemorable Member
      3 years ago

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