Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Slicer has less values than expected

Hi,

I have a slicer called Generation where I see ALL the values are selected.


However, when I expand the list, I see 4 values are available/selected:



... but I am expecting 6 values for this slicer:

 



However, when I click on the filter icon of the slicer, I see:

 

The filter pane also does not say why the 2 values are missing

 


I am wondering how to find the reason behind having less than 6 values available in the slicer ?

Thanks

  • Hello,

     

    First dublicate the page so you could test safely without affecting the main report.

     

    after duplicating the page, remove the slicers one by one to see whats affecting it.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos👍

    Follow me on Linkedin

5 Replies

  • Anonymous , there is a page level filter, is valid =1, remove that and check if this one is giving more values. Also clear visual level filter and check

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi amitchandak 
      I have got rid of all my slicer friends and here is the situation:

       



      Also removed the page level filter, but not more than 4 values.

       

       

      • Idrissshatila's avatar
        Idrissshatila
        Icon for Super User rankSuper User

        Hello,

         

        First dublicate the page so you could test safely without affecting the main report.

         

        after duplicating the page, remove the slicers one by one to see whats affecting it.

         

        If I answered your question, please mark my post as solution, Appreciate your Kudos👍

        Follow me on Linkedin

  • Hello,

    It's affected by other filters, try removing one filter after another and check after each one if the appear so you could see what's affecting it.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos👍

    Follow me on Linkedin

    • Anonymous's avatar
      Anonymous
      Not applicable

      I removed ALL other filters, but no sign of other values unfortunately.