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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors