Master dimension only applies one value color

[kiarapazan]

I have a large set a data where I have rolled up a Project and its associated systems into a single Closure Risk (very low, low, moderate....). I created a master dimension ClosureRisk to do this:

=if(aggr(sum(Aggr(Max([Expected Recovery Duration]),Project,System,Subsystem1,Subsystem2,Subsystem3,Number)),Project)<=4,'Very Low',
if(aggr(sum(Aggr(Max([Expected Recovery Duration]),Project,System,Subsystem1,Subsystem2,Subsystem3,Number)),Project)<=8,'Low',
if(aggr(sum(Aggr(Max([Expected Recovery Duration]),Project,System,Subsystem1,Subsystem2,Subsystem3,Number)),Project)<=12,'Moderate',
if(aggr(sum(Aggr(Max([Expected Recovery Duration]),Project,System,Subsystem1,Subsystem2,Subsystem3,Number)),Project)<=16,'High',
if(aggr(sum(Aggr(Max([Expected Recovery Duration]),Project,System,Subsystem1,Subsystem2,Subsystem3,Number)),Project)>16,'Very High')))))

I assigned  a value color to each risk from the masters dimension menu but the chart only shows color from the first statement (Very low). How can I get the other colors to properly show? Any help/guidance is appreciated. 

[JustinDallas]

Such a problem is kind of difficult to diagnose without source data ='(

[Don_Stocks_]

Drag your master dimension onto your chart again. You'll see a menu popup asking if you want to replace the dimension or color by the master dimension. Select 'Color by".

In my experience it seems that changes to the master dimension value colors don't get applied (or at least don't get applied right way) to charts without taking this action. 

[kiarapazan · Accepted solution]

I tried this and it didn't work. I ultimately found the solution which was deleting the chart and adding it back in. Couldn't believe it was that simple! Thanks