Help with color coding text values in matrix

[Anonymous]

Hello,

I have a Matrix with 3 columns and all of these are text or categorical values like seen below. Significance and Log-Term Significance are both measures and I am interested in color coding their values or backgrounds. For example, Significant should be green and Non-Significant should be Red for both measures. But because these are not numerical values, I am having hard time color coding these.

I was also trying to give 0 and 1 to these values, but for that the column names should not be measures. But these are measures, and therefore I was not able to do so.

Any help with example dax for color coding the results will appreciated!

Thanks!

[DataZoe · Accepted solution]

@selimovd 's approach is correct but to do it with measures, you can change the syntax just a little like this:

Color Significance =
VAR vMaxSelected = [Significance]
RETURN
    SWITCH(
        vMaxSelected,
        "Non-Significant", "red",
        "Significant", "green"
    )

and then on the table, go to Conditional Formatting > Background > then by Field Value > using this measure.

[selimovd]

Hey @Anonymous ,

you can do that with a measure and the conditional formatting:

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

For the measure something like this should do it:

Color Significance =
VAR vMaxSelected = MAX( myTable[Significance] )
RETURN
    SWITCH(
        vMaxSelected,
        "Non-Significant", "red",
        "Significant", "green"
    )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic