Forum Discussion

suneelkethagani's avatar
suneelkethagani
Frequent Visitor
3 years ago

Conditional Formatting with Concatenated Text Values

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...

3 Replies

  • Mikelytics's avatar
    Mikelytics
    Resident Rockstar
    3 years ago

    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's avatar
      Mikelytics
      Resident Rockstar
      3 years ago

      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