Forum Discussion

marjoriefialek's avatar
marjoriefialek
Icon for Helper I rankHelper I
5 years ago

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...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi,

In Power query unpivot the dates column and then use matrix in the desktop. 

see how it works out.

 

marjoriefialek's avatar
marjoriefialek
Icon for Helper I rankHelper I
5 years ago

Unpivotting is multiplying the values but still loosing the zeros when I filter NULLS.