cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Heatmap in a table

Hello everyone!

I have the following table:

BIBITARIFA_0-1675554733345.png

The idea of this table is to compare the number of real agents with the number of calculated agents, and I am trying that in case the values in the "real agents" column are < or > that of the "calculated agents" values the cells have a light red background color. On the other hand, when these values are the same that they have a light green color. Would they know how to do it?

Best regards!! 🙂

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

@BIBITARIFA ,

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

That was it!! This is my measure:

Color = IF(SUM(Operarios_mes_mayo[Num_Operarios])=SUM(DATA[agents]), "#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
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors