How to display the zeros coming from table columns as blanks in a matrix?

[arunbyc]

I have four columns in a matrix. When a column has a non-zero value in any row,  then the row value in the other three columns will be zero. This is showing too many zeros in the matrix and I would rather show blanks. Is there any way to do this? I could only think of writing measures for each column saying "if(column_value = 0, blank( ), column_ value)" and displaying the measures in the matrix instead of the columns. What is a better/easier way to do this? Secondly, If this "measures" approach is followed, will it introduce any unintended complications?

Thanks for your help.

[rajendraongole1 · Accepted solution]

Hi @arunbyc -To display zeros as blanks in a Power BI matrix, your approach of using measures is indeed the most straightforward and effective way.  you've created these measures, good approach and using measures like these has a minimal impact on performance, especially with simple logic like this.The built-in functionality of measures provides a direct way to handle this situation.

Measure_Column1 =
IF([Column1] = 0, BLANK(), [Column1])

measure_c2, measure_c3, measure_c4 and so on...

Hope the above information helps.