Forum Discussion

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

8 Replies

  • Royel's avatar
    Royel
    Icon for Super User rankSuper User
    10 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 

  • grazitti_sapna's avatar
    grazitti_sapna
    Icon for Super User rankSuper 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!

  • Irwan's avatar
    Irwan
    Icon for Super User rankSuper User
    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.
    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      10 months ago

      Hi Manikanta2108 ,
      Thanks for reaching out to the Microsoft fabric community forum. 

       

      I would also take a moment to thank  Irwan  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
      I hope the below details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

      Best Regards, 
      Community Support Team  

       

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        10 months ago

        Hi Manikanta2108 ,

        I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

        Best Regards, 
        Community Support Team.