Forum Discussion
Treemap color with objectives
- 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:
Best Regards,
Giotto Zhi
- 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
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:
Best Regards,
Giotto Zhi
- adiolka6 years agoFrequent Visitor
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