Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 pr...
  • edhans's avatar
    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.

    2020-05-04 13_03_30-Untitled - Power Query Editor.png

    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"