Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Background Color on Measure (Text Field)

Hi Team,   I have created an measure that takes Max of Color and I put that in the matrix.   Measure = Max(Table1[Color])   This is what data looks like:   Company Measure C1 0_Green ...
Need Help
Tips and Tricks
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    You can reference your measure? Are you confused because I've named my measure 'Measure'  and you already have a measure called 'Measure'? 

     

    Here, try this as measure. Then select this measure BGColor in the Conditional Formatting dialogue.

    BGColor = 
VAR col = [Measure]
RETURN
IF(col = "3_red", "Red",
    IF(col = "0_green", "Green",
        IF(col = "2_yellow", "Yellow",
            IF(col = "1_blue", "Blue", "White"))))

     

     

    Kind regards

    Djerro123

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

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Kudo's are welcome 🙂

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

You can reference your measure? Are you confused because I've named my measure 'Measure'  and you already have a measure called 'Measure'? 

 

Here, try this as measure. Then select this measure BGColor in the Conditional Formatting dialogue.

BGColor = 
VAR col = [Measure]
RETURN
IF(col = "3_red", "Red",
    IF(col = "0_green", "Green",
        IF(col = "2_yellow", "Yellow",
            IF(col = "1_blue", "Blue", "White"))))

 

 

Kind regards

Djerro123

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

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Kudo's are welcome 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DJ I messed it up. I selected the column. THanks for help. That actually fixed my issue.