Hide zeros from Matrix

[CarlsBerg999]

Hi,

I have a Matrix table in PBI, which is demonstrated below on Excel. I have conditional formatting: "If value is 0 then font is white". This works fine for "Other Creditors, Advances Received and Accounts Payable". However, for Liabilities to Credit Institutions the underlying measure calculates figures like this: +500 - 500 = 0,00. Therefore because the transactions cancel each other, the conditional formatting is not working. 

Any ideas on how to get the 0,00 in the picture below to be blank? 

[amitchandak · Accepted solution]

@CarlsBerg999 , I see white only for blank, not for 0. Can share condition use.

Or try a measure like

Switch(true() ,

[meausre] = 0, "white",

"black"

)

use this in conditional formatting with field value option