Forum Discussion

Manikanta2108's avatar
Manikanta2108
Icon for Helper I rankHelper I
11 months 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
    11 months 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
11 months 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