How to make pivot table in power bi as same as excel

[Anonymous]

I have such data

I want it to be like this in power bi so that i can use flow map and use count as width

how can i do it help me 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Use group by feature in Power Query Editor:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKk4t0DUyUtJRyi7NS8nJBDJK8/IS85VidUaiXGJGbmpKYlJiyqg8Vvns/JzsxJJEymRjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Month = _t, #"veh location" = _t, #"income location" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Month", type date}, {"veh location", type text}, {"income location", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Month", "veh location", "income location"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
    #"Grouped Rows"

Best Regards,

Jay

[AbbasG]

@Anonymous In Power BI you can use the Matrix visual to get the desired output.

[Anonymous]

yes. but I want to use that as a table in the flow map ( Visual Addin) to show A to B traveeling frequency. using matrix can i do that?

[lukiz84]

YourMeasure = COUNT('Table'[Income Location])