Color Coding based on a dimension in a matrix

[lprabhal]

Hi Everyone,

  I started using Power BI from 2-3days. I am trying to create a report with Matrix. 

  I have taken date(as weeks in columns) and Names in Rows and field1(a dimension basically) and field2(Measure)  in Values. 

  Now i want to color the report based on field1.

  Field1 is having values like this:: a,b,c,d, general etc., 

  If a then 'Green'

  else if b then 'Light Green'

  else if c then 'Red'

  else if d then 'Blue' 

  else 'yellow'

But so far i have seen field1 is taking to summarization and so if i go for conditional formatting i couldn't take as a proper dimension rather it is giving me first/last/count/countd. I couldnt de summarize it and apply color here.

Is there any way that i can apply color to my cells based on the dimension values in a matrix format. 

[v-cherch-msft · Accepted solution]

Hi @lprabhal 

I would suggest you add an index column in query editor and drag it in matrix.Then create a measure and use it in conditional formatting.

Measure = SWITCH(MAX(Table1[filed1]),"a",1,"b",2,"c",3,"d",4,5)

Regards,