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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
harshad_barge
Helper I
Helper I

Unable to change background colour based on rules

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.

Capture.PNG

Can anybody please help?

Please find the pbix file and the dataset

Here

https://filebin.net/0bvp0ygcvgo6uplu

 

Thanks,

Harshad

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

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
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.