Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
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"
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou 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"
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |