Forum Discussion
Create a Dependency Visual
- 6 years ago
You must normalize your data. Select the Name column in Power Query, and then un pivot other columns on the Transform ribbon. It will return the following table. THen can set slicers or filters by project or person.
See the M code below to see what I did.
1) In Power Query, select New Source, and then select Blank Query
2) On the Home ribbon, select the "Advanced Editor"
3) Remove everything you see, then paste the M code I gave you into that box.
4) Tap Donelet Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8srPyFNQ0lGKAGIFOI7VAcokJmdDJSJQJIJLUstSkUQhKkAyTpk5OUiCUC2xAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t, #"Project 1" = _t, #"Project 2" = _t, #"Project 3" = _t, #"Project 4" = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Project 1", type text}, {"Project 2", type text}, {"Project 3", type text}, {"Project 4", type text}}), #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Name"}, "Project", "Dependency") in #"Unpivoted Other Columns"
You must normalize your data. Select the Name column in Power Query, and then un pivot other columns on the Transform ribbon. It will return the following table. THen can set slicers or filters by project or person.
See the M code below to see what I did.
1) In Power Query, select New Source, and then select Blank Query
2) On the Home ribbon, select the "Advanced Editor"
3) Remove everything you see, then paste the M code I gave you into that box.
4) Tap Done
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8srPyFNQ0lGKAGIFOI7VAcokJmdDJSJQJIJLUstSkUQhKkAyTpk5OUiCUC2xAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t, #"Project 1" = _t, #"Project 2" = _t, #"Project 3" = _t, #"Project 4" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Project 1", type text}, {"Project 2", type text}, {"Project 3", type text}, {"Project 4", type text}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Name"}, "Project", "Dependency")
in
#"Unpivoted Other Columns"