Forum Discussion

Sharmi_28's avatar
Sharmi_28
Helper I
2 years ago
Solved

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...
  • Alex87's avatar
    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