Forum Discussion
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 Powe...
Hi,
In Power query unpivot the dates column and then use matrix in the desktop.
see how it works out.
Unpivotting is multiplying the values but still loosing the zeros when I filter NULLS.