Color Text Data Within a Table

[Syndicate_Admin]

Good morning

I would like to know how I can assign a specific color to each type of data that is included within a column (TERM) in a data table (Figure 1). Specifically I want to assign background two colors, green for OK and red for NO OK. You can see how the PLAZO table is constructed and categorized in Figure 2 and 3. Thank you very much in advance for any help or advice you can give me about it.

A greeting

Joseph I. Del Pino B.

Figure 1.

Figure 2.

Figure 3.

[v-cazheng-msft · Accepted solution]

Hi, @Syndicate_Admin 

I agree with timg. Conditional formatting can solve your problem. You can create a Measure as the following and then format your data column with it.

Color_TEXT =

SWITCH ( SELECTEDVALUE ( 'Table'[PLAZO] ), "OK", "Green", "NO OK", "RED" )

The result looks like this:

Best Regards,

Caiyun Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[timg]

Hi,

You can apply these settings through conditional formatting. You can find this in the formatting tab when you have selected the table. 

Best regards,

Tim