Unable to change background colour based on rules

[harshad_barge]

I have built a PBIX file and it has png files as icons. I want to change the bachground colours based on the sum of response score (filtered by the ClientName and the category) but, the colours are taking up as a total of the entire category and hence, not displaying as they are supposed to.

Can anybody please help?

Please find the pbix file and the dataset

Here

https://filebin.net/0bvp0ygcvgo6uplu

Thanks,

Harshad

[v-juanli-msft]

Hi @harshad_barge 

Files you shared with are not the excel file or pbix file.

I can't use the data from them.

how about trying to use a measure instead?

like measure=sum([column])

then use this measure in the conditional fromatting.

Best Regards

Maggie

[amitchandak]

I checked your file. Do you want to change the background behind the icon. The icon does not seem transparent to me. Can explain a bit more

[harshad_barge]

Yes, the background colours of those PNG icons should change based on the rules.