Forum Discussion
Solved
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 ...
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
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