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
