Exclude Columns with ALL zero values

I have a matrix visual with conditional coloring and icons.  In order to accomplish this I had to convert NULLS into zeros.  However, I would like to exclude the columns that have all ZEROS.  In Power Query, when I remove the date columns with nulls I also loose the converted values to zero.  

Examples are included.  

The first image I have all dates with conditional formatting.  The columns in red with NO values at all need to not be there.  

The second image is the same matrix but I excluded the date column with NULLS which eliminates the columns with ALL Zeros but I also loose the Zeros for the other rows/columns and I need them for conditional formatting using values.  I can't replace the NULLS with zeros because they were filtered by removing the NULLS from the date column. 

I was thinking I could use the Grand Total of the column to exclude the column but it doesn't work. 

Any help is appreciated.