Apply a condition on a series of numbers

[Anonymous]

Hey,

I would like to get some help please.

I have a table which is just like that:

Column 1     Column 2      Month 1   Month 2  Month 3...

Category 1 Cateogry 1   Value 1     Value 2    Value 3

Category 1 Category 2   Value 4     Value 5    Value 6

Category 2 Category 1  Value 10   Value 11    Value 12

Category 2 Category 2  Value 13   Value 14   Value 15

.

.

.

.

So I would like to apply a condition to the values, but using a condition formating , I don't have an option to add the column 2 as condition as well :

If column 2 = Categorie 2 then there's a condition on the values

If column 2= Categorie 1 then there's another condition

Thanks

[vjnvinod]

@Anonymous 

If column 2 = Categorie 2 then there's a condition on the values

If column 2= Categorie 1 then there's another condition

what are those conditions?

[Anonymous · Accepted solution]

My condition was that the colour will change if the categorie's name changes.

I've found the solution, i've used

MEASURE = SWITCH(TRUE(),condition,color)

[v-chuncz-msft]

@Anonymous ,

You may add a measure and use Color formatting by field value.