Forum Discussion
Phantom Filter on Grid
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?
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.
9 Replies
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.
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.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.
