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
Anonymous
Not applicable

Mapa de calor en una tabla

Hola a todos! 

 

Tengo la siguiente tabla: 

BIBITARIFA_0-1675554733345.png

La idea de esta tabla es comparar el numero de agentes reales con el número de agentes calculados, y estoy intentado que en caso de que los valores de la columna "agentes reales" sean < o > que la de los valores "agentes calculados" las celdas tengan un color de fondo rojo claro. En cambio, cuando estos valores sean iguales que tengan un color verde claro. ¿Sabrían cómo llevarlo a cabo?

 

Saludos!! 🙂 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous ,

Have you checked measure based conditional formatting

Also if you are able to create a diff measure, you should able to use conditional gradient formatting

 

a measure like Sum(Table[real agents]) - sum(Table[calculated agents])

 

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/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

 

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous ,

Have you checked measure based conditional formatting

Also if you are able to create a diff measure, you should able to use conditional gradient formatting

 

a measure like Sum(Table[real agents]) - sum(Table[calculated agents])

 

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/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

 

Anonymous
Not applicable

That was it!! This is my measure: 

Color = IF(SUM(Operarios_mes_mayo[Num_Operarios])=SUM(DATOS[agentes]), "#BFEEBC", "#F2B1A2"). I created and put it in the Background color --> Conditional Formatting: based on field. It's all and it's worked. Thank you Amit. 

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
Top Kudoed Authors