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...
You can add a column to work as a flag: if the sum total value on a date is not zero, then flag is 1; if the sum total value on a date is zero, then flag is 0. Then apply this flag column to the matrix as a visual filter which sets value is 1.
Flag = IF(CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Date]))<>0,1,0)Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
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.
