Forum Discussion
Create a Dependency Visual
I am looking to create a view that shows stakeholders and the programs that they are dependent on. I attempted to do this with a tree view but it only allows me to show the stakeholders under each program. Is there a view that would allow me to show that ex. Jack is dependent on Program 1 and Program 2 without simply listing the stakeholders under each project?
| Project 1 | Project 2 | Project 3 | Project 4 | |
| John | X | |||
| Jack | X | X | ||
| Steve | X | X | X | |
| Bill | X |
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"
1 Reply
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"