Once you filter facts, entire rows are hidden if values in a number of columns You should not meet up with the filtering conditions. You are able to filter on numeric or text values, or filter by color for cells that have color formatting placed on their history or text. https://connerrdrcn.liberty-blog.com/34219179/about-auto-filter