controlling drill up text values in matrix visual

[jums]

I have the following dataset

1)I  have created a calculated column to colour code, Statuscode =

SWITCH(

    TRUE(),

    'superstore_dataset2011-20151'[Status] ="In Progress",1,

   'superstore_dataset2011-20151'[Status] = "On Hold",2,

   'superstore_dataset2011-20151'[Status] = "Planned",3

)

And then use colour conditional formatting  but the colours are not showing on all status

In progress =yellow, planned =blue on hold is pink

2) If I drill up to the city the matrix is assigning a wrong status value, I would like to control that drill up value and call it multiple to differentiate it from other status value . Below is a screenshot of each scenario

1 when I don’t drill down , to the Customer Name under the city Kabul,it is showing the right status for each person though not well colour coded

2) when I drill up to the city Kabul it is showing all In progress and not colour coding

3) I want to know how to drill up to the city Kabul (and all other cities) with multiple customers and status on each category and assign a customized status value named multiple

I am want to see

[lbendlin]

when you specify the conditional formatting you can decide if you want to appy this to values, totals, or both. In your scenario you seem to want to select "both".