Forum Discussion
Show empty instead 0 in the Matrix Table
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
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]) + 0Put 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.
3 Replies
Try power query UI.
But remember zero and blank are give two different meanings.Hi Nalakan, I tried some formats of number in power query but the matter is still.
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]) + 0Put 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.
