Forum Discussion
Individual Number Formatting
Hi all, I was wondering whether there was a way of changing the format of the data so that only the bottom row's numbers show as a percentage, rather than each whole column. Apologi...
Hi Anonymous,
See below an image of how to do the unpivot and pivot on the query editor.
The selection of the columns for the unpivot should compreend all your months.
Regards,
MFelix
Hi Anonymous,
The best way is to unpivot your columns and then Pivot by the Contact Quality.
Check below the M Code for some sample data:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wck7MySlW0lEytDAGk4Yg0tJAKVYnWsmxLLUoMT0VKGKgZ2lhaYjGMDczUYqNBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Contact quality" = _t, Jan = _t, Feb = _t, Mar = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Contact quality", type text}, {"Jan", type number}, {"Feb", type number}, {"Mar", type number}}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Contact quality"}, "Attribute", "Value"),
#"Pivoted Column" = Table.Pivot(#"Unpivoted Columns", List.Distinct(#"Unpivoted Columns"[Contact quality]), "Contact quality", "Value"),
#"Changed Type1" = Table.TransformColumnTypes(#"Pivoted Column",{{"Average", Percentage.Type}})
in
#"Changed Type1"
Regards,
MFelix
Hi Anonymous,
See below an image of how to do the unpivot and pivot on the query editor.
The selection of the columns for the unpivot should compreend all your months.
Regards,
MFelix