Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Matrix Conditional Formatting when all values are zero

Hello,   I'm using conditional formatting in a matrix to set the background color based on color scale. However, when all the values in the column are zero (not null or blank), the color defaults t...
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , I think that is expected behavior, if all values are the same then it is treated as max

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I understand this is expected behavior, I'm asking if it's possible to change this behavior through some Power BI guru magic!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Did you ever get this solved?
      I am running into the exact same problem.

    • aj1973's avatar
      aj1973
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Anonymous 

      The Guru magic is then found in DAX. Create a DAX forumla and use it your Matrix.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        How would I get DAX to emulate what I'm looking for? As far as I can tell, if all values remain the same (i.e. zero) the result will be the same (maximum color scale).