Forum Discussion
Hide zeros from Matrix
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?
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
1 Reply
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