Forum Discussion
Presenting data in Matrix table
Your source data is not in a usable format. First step is to modify the structure to make it usable.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTIFYmMgNjIwMtI1MNQ1gHMMjXSNDZRidaKVnKBqTJHVmUA4xlAOSJ0zUMgQoQ4iZQjnGIEMj40FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Work ID" = _t, #"ITG0.1 Tollgate decision" = _t, #"ITG0 Tollgate decision" = _t, #"ITG0.1 Decision Date" = _t, #"ITG0 Decision Date" = _t]), #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Work ID"}, "Attribute", "Value"), #"Split Column by Delimiter" = Table.SplitColumn(#"Unpivoted Other Columns", "Attribute", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"Level", "Attribute"}), #"Pivoted Column" = Table.Pivot(#"Split Column by Delimiter", List.Distinct(#"Split Column by Delimiter"[Attribute]), "Attribute", "Value", List.Max) in #"Pivoted Column"Then you can use conditional formatting to achieve your desired result.
see attached
Your sample data is inconsistent. What is the correlation between ITG0.1, IT0.1 and ITG0 ?
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Your source data is not in a usable format. First step is to modify the structure to make it usable.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTIFYmMgNjIwMtI1MNQ1gHMMjXSNDZRidaKVnKBqTJHVmUA4xlAOSJ0zUMgQoQ4iZQjnGIEMj40FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Work ID" = _t, #"ITG0.1 Tollgate decision" = _t, #"ITG0 Tollgate decision" = _t, #"ITG0.1 Decision Date" = _t, #"ITG0 Decision Date" = _t]), #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Work ID"}, "Attribute", "Value"), #"Split Column by Delimiter" = Table.SplitColumn(#"Unpivoted Other Columns", "Attribute", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"Level", "Attribute"}), #"Pivoted Column" = Table.Pivot(#"Split Column by Delimiter", List.Distinct(#"Split Column by Delimiter"[Attribute]), "Attribute", "Value", List.Max) in #"Pivoted Column"Then you can use conditional formatting to achieve your desired result.
see attached
