Forum Discussion

harshad_barge's avatar
harshad_barge
Icon for Helper I rankHelper I
6 years ago

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.

Can anybody please help?

Please find the pbix file and the dataset

Here

https://filebin.net/0bvp0ygcvgo6uplu

 

Thanks,

Harshad

Need Help
Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      harshad_barge
      Icon for Helper I rankHelper I
      6 years ago
      Yes, the background colours of those PNG icons should change based on the rules.
  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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