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.

mattsuderman's avatar
mattsuderman
Frequent Visitor
2 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    mattsuderman
    Frequent Visitor
    2 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      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.

      • mattsuderman's avatar
        mattsuderman
        Frequent Visitor
        2 years ago

        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.