Change Color on Pie Chart that is calculation

[Anonymous]

How can i change the color on the pie chart , where and how I would put the calculation.

I can change the colors in colors mode. but the colors do not always stay there. I would like to hardcode as shown but the calculation is not working.

Can someone please help.

[Anil_Babu_Samineni]

May be try this for your measure Background from Expansion + symbol

If(Aggr(FirstSortedValue(DISTINCT [Inherent Risk],-Level),[Seller Symbol],Sector)='High', Green(),

If(Aggr(FirstSortedValue(DISTINCT [Inherent Risk],-Level),[Seller Symbol],Sector)='Low', Red(),

If(Aggr(FirstSortedValue(DISTINCT [Inherent Risk],-Level),[Seller Symbol],Sector)='Medium', LightCyan(),

LightMagenta())))

[Anonymous]

anil babu can i get your email.

[Anonymous]

No, the data is not loading correctly,

Please answer using this updated QV Document

!

[Anil_Babu_Samineni · Accepted solution]

You are not getting this?