Forum Discussion

Manikanta2108's avatar
Manikanta2108
Icon for Helper I rankHelper I
1 year ago
Solved

Background Colour - conditional formatting

Instead of whole background of cell i want to apply background for number only, How can i do that? and here C, H, M, L, I are my measures(values field) in matrix visual    
Need Help
  • Irwan's avatar
    Irwan
    1 year ago

    hello Manikanta2108 

     

     

    H Color =
    IF(
        not ISBLANK(SELECTEDVALUE('Table'[H])),
        "#FF0000"
    )
     
    This should be color any row with no blank value.
     
    Hope this will help.
    Thank you.
Royel's avatar
Royel
Icon for Super User rankSuper User
1 year ago

Hi Manikanta2108 in power bi when you apply background conditional formatting, the entire cell gets colored. For now you can consider it as a limitations of power bi.

 

However you can do the same things by appling same conditional formatting for font color.

 

Thanks