Show empty instead 0 in the Matrix Table

[Thang_Doan]

 

Hi, I need help to show Blank or Empty value replaced for 0 value in the Matrix Table.

I tried to cutomize it in the Visual Setting (Row subtotal, Specific Column, Cell Element) but found nothing.

Thank you for you help

[Anonymous · Accepted solution]

Hi @Thang_Doan 

For your question, here is the method I provided:

Here's some dummy data

“Table”

You can create a measure.

Measure = SUM('Table'[Values]) + 0

Put measure into the "Values" of the matrix.

Here is the result.

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nalakan]

Try power query UI.
But remember zero and blank are give two different meanings.

[Thang_Doan]

Hi Nalakan, I tried some formats of number in power query but the matter is still.