Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
Solved! Go to Solution.
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:
Proud to be a Super User!
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
Proud to be a 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:
Proud to be a Super User!