Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Conditional Formatting in Matrix Ignores Blank Cells

Hey there!   As stated in the title, I am trying to color cells in a matrix but the blank cells are ignoring the conditional formatting.   I have the following dummy data for my project assignmen...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Try like

 

new measure = [_countingMeasure] +0 

_colorBackgroundAllBlanks = 
IF([_countingMeasure] =0 , "Red", "Yellow")

 

Blank will not color, even if we use isblank. We need to have a measure with a 0 value .

 

Try to use measure only in conditional formatting and not in visual and check if that works

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak, thanks for your suggestion!

    You mean to use the new measure in _colorBackgroundAllBlanks?

     

    new measure = [_countingMeasure] +0 

_colorBackgroundAllBlanks = 
IF([new measure] = 0, "Red", "Yellow")

     

     Sadly, it does not seem to work. I still get the same table as earlier:

    And even if I use the new measure directly in the matrix, I can't get it to display the zeros. (Which is very strange, in another report I get the zeros by adding "+0" with no issues.)

    Do I interpret your answer correctly that regarding the main issue with coloring the current week's column including blanks - it is not possible to do so at the moment unless maybe we add in zeros to the matrix, change their font color so they're invisible, etc. ?