Forum Discussion

cpunnett's avatar
cpunnett
Icon for Helper II rankHelper II
9 years ago
Solved

Slicer not showing all values

I have 1 simple table with about 566k rows.  One column has 3 distinct values.  I added a slicer for that column and only 1 value shows up, why is that?
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    There has to be something else that's filtering it. Is there anything else on the page? Some other slicer, some other visual? Are there any page level or report level filters?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I just had this problem and solved it by:

 

Clicking the View tab at the top of the window > Checking the Selection Pane box > Clicking through each "Slicer" in the selection pane

 

I found that there was a hidden slicer that was preventing me from seeing all of the values in the slicer I was trying to create. Once I deleted this slicer, all of the values that I expected appeared.

  • kategrass's avatar
    kategrass
    Frequent Visitor
    8 years ago

    Thank you!!!! Just had the same problem and wasn't aware of the hidden slicers left behind when I removed other page with synced slicers. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thak you! You´re the best.

  • Roux's avatar
    Roux
    New Member
    3 years ago

    Hi there. I have clicked into 'Filters On Visual' which shows x 3 I have selected. When I export, it only shows me one column which is the date range? Any help gratefully received. 

  • Heena05's avatar
    Heena05
    New Member
    7 months ago

    Thanks ,That helped.I duplicated the page where I used show hide slicer and didnt realise that the slicer was hidden .