How to create both from and to in same column to use hierarchy in power bi using matrix visual

[Uldevi]

Hi,

How can I add the "From" and "To" column for the hierarchy as shown in the image? Could you please help me with this? 

I want to count the number of people who transferred from one location to another, grouped by region and location.

 thanks,

[Fowmy · Accepted solution]

@Uldevi 

You need to first UnPivot the lat two columns (From and To) then use a simple measure to Count the ROWS: file attached.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8sxLyUxU0lHySszTNTIBMooS87IySzKALJfUnIxMIO2UnlOkFKuDUOuWmqRrZIqiFqxGR8m3NDcpMRNFsW9ipa6RGYriXIgqHaXs/OzEkkQ05UUQd5RlFiVm4XNFcGqBrpE5kkrcbvBPLtE1tERSiuGCWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [country = _t, date = _t, name = _t, #"transferred from" = _t, #"transferred to" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"country", type text}, {"date", type date}, {"name", type text}, {"transferred from", type text}, {"transferred to", type text}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"country", "date", "name"}, "FromTo", "Location")
in
    #"Unpivoted Other Columns"