Background Colour - conditional formatting

[Manikanta2108]

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

[Irwan · Accepted solution]

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]

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]

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.

[v-menakakota]

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.

[grazitti_sapna]

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]

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

[Royel]

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 

[raisurrahman]

@Manikanta2108 : very interesting requirement. I never think in this way.


I will try to give it a try when I have got time