Forum Discussion

Manikanta2108's avatar
Manikanta2108
Helper I
10 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
    10 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.
grazitti_sapna's avatar
grazitti_sapna
Super User
10 months ago

Hi Manikanta2108,

 

there is no such conditional formatting available, but you can try below DAX add it to background color of the cell, you can tweak the esle part of if as per your requirement

 

BG_Color_C =
SWITCH(
TRUE(),
ISBLANK([C]), "#FFFFFF",
[C] > 100, "#FF9999",
[C] > 50, "#FFFF99",
"#99FF99"
)

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

  • Manikanta2108's avatar
    Manikanta2108
    Helper I
    10 months ago

    tried the above dax you provided its not working for me.