Forum Discussion

jums's avatar
jums
Frequent Visitor
3 years ago

controlling drill up text values in matrix visual

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

 

 

1 Reply

  • 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".