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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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