Conditional Formatting with Concatenated Text Values

[suneelkethagani]

Hi everyone,

I have a question, for below the Matrix Chart I need conditional formatting. For Project ID "Pr2" in Apr-22, I have values M2, M3 and M4. I need conditional formatting for that type of values, if it has multi in each cell. For M2 I need Red Color for M3 and M4 I need Green Color.

Can you please suggest me the DAX Code?

Thanks in Advance...

[Jitendra_Soni]

I would also like to know the solution of this.

[Mikelytics]

Hi @suneelkethagani 

Unfortunately it is only possible to format a cell as a whole and not the single objects within a cell.

Best regards

Michael

-----------------------------------------------------

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

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

[Mikelytics]

Hi @suneelkethagani 

a small additional comment to make it complete. You can do formatting with DAX using the FORMAT() function in general (like formatting into percentage). But **bleep** does not include color-coding.

Best regards

Michael