Have Month column in matrix Visual Columns fields

[Anonymous]

Hi All,

Good Day!!

I have table with Process, Month & SLA status, need your help to bring the month column in Table visual Columns like

Table

Process	Month	SLA status
AP	8-Aug	Missed
AP	9-Sep	Met
AP	10-Oct	Missed
AR	8-Aug	Missed
AR	9-Sep	Met
AR	10-Oct	Missed
GA	8-Aug	Missed
GA	9-Sep	Met
GA	10-Oct	Missed

in Power Matrix Visual like below

Process	Aug	Sep	Oct
AP	Met	Missed	Met
AR	Met	Met	Missed
GA	Met	Missed	Met

Thanks in advance.

[v-yulgu-msft]

Hi @Anonymous,

Create a calculated column.

MonthName = RIGHT(Table5[Month],3)

Insert a Matrix visual.

Best regards,

Yuliana Gu

[PattemManohar · Accepted solution]

@Anonymous Could you please check your expected output...

Is it something like this you are looking for....

Please try this in "Power Query"...

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcgxQ0lGy0HUsTQfSvpnFxakpSrE6UHFL3eDUApB4aglC0NBA1z+5BE11EA5TgrCZEoTDFHdH7KaAxdFNAQtimBILAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Process = _t, Month = _t, #"SLA status" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Process", type text}, {"Month", type text}, {"SLA status", type text}}),
    #"Inserted Text After Delimiter" = Table.AddColumn(#"Changed Type", "Text After Delimiter", each Text.AfterDelimiter([Month], "-"), type text),
    #"Renamed Columns" = Table.RenameColumns(#"Inserted Text After Delimiter",{{"Text After Delimiter", "MonthNew"}}),
    #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"Month"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[MonthNew]), "MonthNew", "SLA status")
in
    #"Pivoted Column"