Coloring Table with different textvalues

[KBO]

Hi,

I like to know how I can coloring text values in a table. If I use "If" in DAX it only shows me Measures. For example I have a table with empolyees from whom I would like to know when they are in a Projekt and when they have vacation time. So my question is there any DAX funktion wich can show me that?

Best,

Kathrin

[v-juanli-msft · Accepted solution]

Hi @KBO

I made a test to illustrate.

Since your requirement is not completely stated, I would like to supplement it as below:

If empolyees are in a Projekt, text values column "empolyees" of in a table should be colored as red.

Create a measure to indicate which empolyees are in a Projekt.

Measure 3 = IF(MAX([time])="Projekt",1,0)

Then set conditional formatting in a table visual.

Reference:

Conditional formatting in tables

Best Regards

Maggie

[KBO]

Sorry, but that's not exactly what I was looking for. It's a little bit complcated to explain it exact but If I found a solution I will reply it here.

[jthomson]

In lieu of them actually getting conditional formatting working out of the box for text based fields, you could try to create some sort of measure that'll give you a 1 for yes, 0 for no result for each employee depending on the exact logic you want to use and then format based off of that?