Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Color 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...
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    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.

     

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

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.