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...
I suggest remaining all Zeros rather than NULLs in Power Query just as the first image in your original post, then adding the flag column as a filter with value 1. Here is a sample PBIX file for reference. Let me know if you have any questions.