Forum Discussion

adiolka's avatar
adiolka
Frequent Visitor
6 years ago
Solved

Treemap color with objectives

Hello,   I hope that there werent similar post about my problem - i havent found anything similar. I have questions about treemap color with objectives. In my project i have result and i want a...
  • v-gizhi-msft's avatar
    6 years ago

    Hi,

     

    According to your description, I create a table to test:

    Please take following steps:

    1)Create a measure to set conditional format color:

    Measure = 
    SWITCH (
        TRUE,
        SELECTEDVALUE ( 'Table'[Scores] ) < 50 * 0.9, "#800000",
        SELECTEDVALUE ( 'Table'[Scores] ) > 50 * 0.9
            && SELECTEDVALUE ( 'Table'[Scores] ) < 50 * 0.92, "#B50000",
        SELECTEDVALUE ( 'Table'[Scores] ) > 50 * 0.92
            && SELECTEDVALUE ( 'Table'[Scores] ) < 50 * 0.94, "#FF0000",
        SELECTEDVALUE ( 'Table'[Scores] ) > 50 * 0.94
            && SELECTEDVALUE ( 'Table'[Scores] ) < 50 * 0.96, "#B55B00",
        SELECTEDVALUE ( 'Table'[Scores] ) > 50 * 0.96
            && SELECTEDVALUE ( 'Table'[Scores] ) < 50 * 0.98, "#FFC300",
        SELECTEDVALUE ( 'Table'[Scores] ) > 50 * 0.98
            && SELECTEDVALUE ( 'Table'[Scores] ) < 50 * 1, "#FFFF00",
        SELECTEDVALUE ( 'Table'[Scores] ) > 50 * 1
            && SELECTEDVALUE ( 'Table'[Scores] ) < 50 * 1.02, "#00FF00",
        SELECTEDVALUE ( 'Table'[Scores] ) > 50 * 1.02
            && SELECTEDVALUE ( 'Table'[Scores] ) < 50 * 1.04, "#00D100",
        SELECTEDVALUE ( 'Table'[Scores] ) > 50 * 1.04
            && SELECTEDVALUE ( 'Table'[Scores] ) < 50 * 1.06, "#00A000",
        SELECTEDVALUE ( 'Table'[Scores] ) > 50 * 1.06
            && SELECTEDVALUE ( 'Table'[Scores] ) < 50 * 1.08, "#006900",
        SELECTEDVALUE ( 'Table'[Scores] ) > 50 * 1.08
            && SELECTEDVALUE ( 'Table'[Scores] ) < 50 * 1.1, "#004500",
        SELECTEDVALUE ( 'Table'[Scores] ) > 50 * 1.1, "#004000"
    )

    And it shows:

    2)Create a calculated table:

    Standard = ADDCOLUMNS(GENERATESERIES(-0.1,0.12,0.02),"Level",[Value]*0+1)

    Then, add a column to this table:

    Column = ROUND(Standard[Value],2)

    3)Create a measure to set this calculated table's conditional format color:

    Measure 2 = 
    SWITCH (
        TRUE,
        SELECTEDVALUE ( Standard[Column] ) = -0.1, "#800000",
        SELECTEDVALUE ( Standard[Column] ) = -0.08, "#B50000",
        SELECTEDVALUE ( Standard[Column] ) = -0.06, "#FF0000",
        SELECTEDVALUE ( Standard[Column] ) = -0.04, "#B55B00",
        SELECTEDVALUE ( Standard[Column] ) = -0.02, "#FFC300",
        SELECTEDVALUE ( Standard[Column] ) = 0, "#FFFF00",
        SELECTEDVALUE ( Standard[Column] ) = 0.02, "#00FF00",
        SELECTEDVALUE ( Standard[Column] ) = 0.04, "#00D100",
        SELECTEDVALUE ( Standard[Column] ) = 0.06, "#00A000",
        SELECTEDVALUE ( Standard[Column] ) = 0.08, "#006900",
        SELECTEDVALUE ( Standard[Column] ) = 0.1, "#004500"
    )

    4)Choose a treemap visual:

    And it shows:

    Here is my test pbix file:

    pbix 

     

    Best Regards,

    Giotto Zhi

     

  • adiolka's avatar
    adiolka
    6 years ago

    v-gizhi-msft 

    Thank u so much i really appreciate your help 🙂 
    I did it. 

    For everyone which have problem like mine, must folow like on the picture below