Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hola a todos!
Tengo la siguiente tabla:
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!! 🙂
Solved! Go to Solution.
@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 ,
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
That was it!! This is my measure:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!