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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors