Forum Discussion

mattsuderman's avatar
mattsuderman
Frequent Visitor
2 years ago
Solved

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....
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

ExcelMonke's avatar
ExcelMonke
Icon for Impactful Individual rankImpactful Individual
2 years ago

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.