Phantom Filter on Grid

[mattsuderman]

I have a Grid that is not showing all data. There seems to be a phantom Filter only showing certain Status values. But I can't find it.

The Dropdown for Filters on the Grid only show two filters.

You can see from other grids on the page that there are other Status values that should be displayed.

I've looked at ALL slicers in Selection View.

What the heck is happening?

[mattsuderman]

So, yeah...already checked the Selection pane.

The First filter is a page filter....if you compare the COUNTS in the Status Grid below, you will see there are 70k REJ records and other status values that do NOT show up in the grid. 

This is the problem. I can't find why this is happening.

[RossEdwards]

The grid at the bottom has a scroll bar.  Do you simply need to scroll down?

[mattsuderman]

The grid at the bottom isn't the problem. It's showing data properly.

The big grid on top is the one that has the hidden filter.

[RossEdwards]

What filter do you think is hidden?  The two filters shown are your 2 slicers:

Reqdte "Last 6 Months" (top left) and the button next to it that has "First" selected.

[mattsuderman]

Thanks for you help....

There is a single data set behind all the grids in the screenshot. There are no page filters. As you can see from the lower grid there are several Status Values...REJ, OB, CALC, PREOF with counts indicating there are records with those status values.

But these records do not show in the grid.

I hope I've explained the problem clearly enough.

[RossEdwards · Accepted solution]

I don't think the issue is hidden filters, i think the issue is the columns in your top grid.  There is something about the columns in your top grid that is causes certain records to have "blank" results and are thus hidden.  From your screenshot, you can see that the top grid only has 2 filters applied, both are your slicers.

To test my theory, remove every column from the top grid besides Status and Cnt.  If you suddenly get the correct numbers, you know its one of the columns that were removed. You can then individually add them back in until the numbers disappear again.

[mattsuderman]

YOU WERE TO RIGHT!

I had a column that was a Sum of a value that was only on some records. This seems to have caused only records with a value in this field to be shown.

Thank you for your patience.

[RossEdwards]

In the "View" menu, there is a toggle for the Selection pane.  Turn that on and look for any hidden slicers.

[ExcelMonke]

Is this in Desktop or on the Server? I do notice that in addition to the filters, you also have a slicer that has "First" Selected. To note, in the Desktop version there is the option to hide a filter- so make sure that that is also unchecked.