Forum Discussion
Sharmi_28
2 years agoHelper I
Apply background colour to card using single Measure
I have table with 7 columns I am using New card visual I want to apply background colour using single Measure If SUM(Table[1]) > 1 , "Green", "Red" If SUM(Table[2]) > 1 , "Green", "Re...
- 2 years ago
yes, CF on background using only one measure as in your request:
CF_Background = SWITCH( TRUE(), SUM(Test[Value]) > 1, "Green", "Red" )I did change the structure in Power Query as well, though, I unpivoted the data
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjVR0lEyNQMSBkBsZg5imZlCuUDJ2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"1" = _t, #"2" = _t, #"3" = _t, #"4" = _t, #"5" = _t, #"6" = _t, #"7" = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"1", Int64.Type}, {"2", Int64.Type}, {"3", Int64.Type}, {"4", Int64.Type}, {"5", Int64.Type}, {"6", Int64.Type}, {"7", Int64.Type}}), #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value") in #"Unpivoted Columns"so that it looks like this:
I then used the Matric visual, swithched in the option pane the values to rows, applied the CF on text and background
Alex87
2 years agoSolution Sage
yes, CF on background using only one measure as in your request:
CF_Background =
SWITCH(
TRUE(),
SUM(Test[Value]) > 1, "Green",
"Red"
)I did change the structure in Power Query as well, though, I unpivoted the data
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjVR0lEyNQMSBkBsZg5imZlCuUDJ2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"1" = _t, #"2" = _t, #"3" = _t, #"4" = _t, #"5" = _t, #"6" = _t, #"7" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"1", Int64.Type}, {"2", Int64.Type}, {"3", Int64.Type}, {"4", Int64.Type}, {"5", Int64.Type}, {"6", Int64.Type}, {"7", Int64.Type}}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value")
in
#"Unpivoted Columns"so that it looks like this:
I then used the Matric visual, swithched in the option pane the values to rows, applied the CF on text and background