How to Filter Tables to Show Only Specific Values in Columns and Rows

is there any option where we can apply a filter to show only those columns and rows where there is specific value? Example I've a table where there are "0" values in all the cells of multiple columns. I want to only show those columns where there are "0" values. I tried applying the filter manually, but it's taking a lot of time. I tried using AI Formula, but still it would require at least one column to be selected, which is not applicable in this scenario I guess. Any other route to explore?