Forum Discussion
Filtering Table report
Hi all, when I filter the Table in report view I am seeing 18 items but only 11 rows are showing up. I checked and I have no other filter on. I even checked the Table view and applied the same filtering and I am seeing the 18 rows. Why am I not seeing the same number of rows in the Table as in the filter? hope you can help thanks.
Hi Anonymous - can you add your unique ID / primary key column to the table visual, if row count jumps to 18, grouping is confirmed as the cause., then click on an empty area of the canvas to clear any cross-filter selections, then recheck your row count. use dont summarize on the column that you are placed in fields .
Hope this helps.
4 Replies
Hi Anonymous - can you add your unique ID / primary key column to the table visual, if row count jumps to 18, grouping is confirmed as the cause., then click on an empty area of the canvas to clear any cross-filter selections, then recheck your row count. use dont summarize on the column that you are placed in fields .
Hope this helps.
Hi rajendraongole1 yes i have realised that it has nothing to do with filters on the table or the page instead I have that I need to have a column in the source file with a unique value filled in each cell. The rows I was not seeing was because the rows contained same data and a lot of missing data as well.
Hi Anonymous,
if the data in the table only contains a subset of the whole number of columns in your actual table view, the table might show less because of duplicate values.
E.g. table view:
first name last name birthdate max mustermann 01.01.2000 max mustermann 02.02.2020 If you then only take the columns "first name" and "last name" in your table it will show 1 row, not 2.
first name last name max mustermann Hope this helps!?
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution
