Forum Discussion
AdministratorColor Text Data Within a Table
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.
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.
2 Replies
- timg
Solution Sage
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
v-cazheng-msftCommunity Support
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.
