Forum Discussion
Solved
Two columns connection
Hello guys First time here! Thanks in advance. Really need some help with a basic two columns connection. Here is an example of what I need. I have these two columns, the names of people that...
Hi NPHOMER ,
Please try below steps:
1. below is my test table
Table:
2. unpivoted table and filter value in Power Query
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCijKz0pNLlEwVNJR8srPyANSSrE6CHEjoIBvYlElurgxDnETHOaYAgUCEktzYNqQ5cwQesBKkOXMcdhjga4nFgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Project = _t, #"Project Owner 1" = _t, #"Project Owner 2" = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Project", type text}, {"Project Owner 1", type text}, {"Project Owner 2", type text}}), #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Project"}, "Attribute", "Value"), #"Renamed Columns" = Table.RenameColumns(#"Unpivoted Other Columns",{{"Attribute", "Project Owner"}, {"Value", "Name"}}), #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each ([Name] <> "")) in #"Filtered Rows"3. add a Clustered bar chart with fields
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi NPHOMER ,
Please try below steps:
1. below is my test table
Table:
2. unpivoted table and filter value in Power Query
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCijKz0pNLlEwVNJR8srPyANSSrE6CHEjoIBvYlElurgxDnETHOaYAgUCEktzYNqQ5cwQesBKkOXMcdhjga4nFgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Project = _t, #"Project Owner 1" = _t, #"Project Owner 2" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Project", type text}, {"Project Owner 1", type text}, {"Project Owner 2", type text}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Project"}, "Attribute", "Value"),
#"Renamed Columns" = Table.RenameColumns(#"Unpivoted Other Columns",{{"Attribute", "Project Owner"}, {"Value", "Name"}}),
#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each ([Name] <> ""))
in
#"Filtered Rows"
3. add a Clustered bar chart with fields
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.