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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
manuelacardonan
Frequent Visitor

Formato condicional a columna texto

Hola a todos

 

tengo una columna condicional tipo texto, con dos valores "a tiempo" y "tarde", necesito dar formato de color sea al texto o al fondo, donde de acuerdo al valor sea el formato de la celda? Como puedo hacerlo?

 

En este caso necesitaria que las celdas que dicen a tiempo esten en color verde y las que dicen tarde en color rojo

manuelacardonan_0-1680538069054.png

 

muchas gracias

1 REPLY 1
amitchandak
Super User
Super User

@manuelacardonan , In Feb 2023, you have option for that in rule based

 

Feb 2023 Feature- Conditional formatting based on string fields: https://youtu.be/Fq0JneLDbGs

 

Also, you can do that using a measure and field value option

 

Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .75 , "Amber" ,
"Red "
)

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.