Forum Discussion
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?
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?
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.
Thanks ,That helped.I duplicated the page where I used show hide slicer and didnt realise that the slicer was hidden .