Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Redopel
Frequent Visitor

Row Background - Conditional formatting color

hello:

How can I conditional format the color in this table( in 'Descargado' column) , when  the values in the ‘Descargado’ column are NO, and the values in the ‘Facturado’ column are YES.

 

Redopel_1-1712180038574.png

 

1 ACCEPTED SOLUTION
_AAndrade
Super User
Super User

Hi @Redopel,

You can do this using conditional format.

For that use this formula:

Color Descargado = 
IF(
    SELECTEDVALUE('T_CondFormat (2)'[Descargado]) = "NO" && SELECTEDVALUE('T_CondFormat (2)'[Facturado]) = "SI",
    "RED"
)


And after go to Format --> Cell elements --> Choose Column Descargado and set the Color Descargado measure as a Background Color.

Like this:

_AAndrade_0-1712181672459.png

 

_AAndrade_1-1712181684819.png

 







Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Redopel
Frequent Visitor

Very grateful, it’s what I needed

Great! If this post has solved your problem, accept my post as a solution and give it a kudo, I'll be very grateful





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




_AAndrade
Super User
Super User

Hi @Redopel,

You can do this using conditional format.

For that use this formula:

Color Descargado = 
IF(
    SELECTEDVALUE('T_CondFormat (2)'[Descargado]) = "NO" && SELECTEDVALUE('T_CondFormat (2)'[Facturado]) = "SI",
    "RED"
)


And after go to Format --> Cell elements --> Choose Column Descargado and set the Color Descargado measure as a Background Color.

Like this:

_AAndrade_0-1712181672459.png

 

_AAndrade_1-1712181684819.png

 







Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors