Forum Discussion

Eddlugonz's avatar
Eddlugonz
New Member
6 years ago
Solved

Conditional Formatting - Two Variables or more

Greetings to all, I hope you will be all right! I would currently like to know if it is possible to conditionally format two or more values in a single array. My example case is as follows: I have ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Eddlugonz 

    Hope you mean in a sinle array is a single column.

    Create a measure as

    sold_stat = SWITCH(true(),

                       [col1] = "Sold",1,

                       [col1] = "Sold out",1,

                       [col1] = "Not Sold",1,0)

    You change chage your conditions as per your requirement. this is what I could make out of it.

    Then in the table or matrix go to formatting and Conditional formatting.

    Select sold_stat and apply the format.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Eddlugonz 

Hope you mean in a sinle array is a single column.

Create a measure as

sold_stat = SWITCH(true(),

                   [col1] = "Sold",1,

                   [col1] = "Sold out",1,

                   [col1] = "Not Sold",1,0)

You change chage your conditions as per your requirement. this is what I could make out of it.

Then in the table or matrix go to formatting and Conditional formatting.

Select sold_stat and apply the format.