Slicer has less values than expected

[Saniat]

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

[Idrissshatila]

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

[Saniat]

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

[amitchandak]

@Saniat , 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

[Saniat]

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 · Accepted solution]

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