Forum Discussion
Bar chart in Power BI
- 5 years ago
You need to transform your table in Power Query:
Go to Power Query > Get Data > Blank Query > go to Advanced Editor in View Menu, Clear all that is there and paste the below code.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlDSUTJUitWJBpKYLFRZA6XYWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Class 1" = _t, #"Class 2" = _t]), #"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type), #"Changed Type" = Table.TransformColumnTypes(#"Added Index",{{"Class 1", Int64.Type}, {"Class 2", Int64.Type}}), #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Index"}, "Attribute", "Value"), #"Duplicated Column" = Table.DuplicateColumn(#"Unpivoted Other Columns", "Value", "Value - Copy"), #"Removed Columns" = Table.RemoveColumns(#"Duplicated Column",{"Index"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Value", "Legend"}, {"Attribute", "Class"}, {"Value - Copy", "Value"}}) in #"Renamed Columns"________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š
You need to transform your table in Power Query:
Go to Power Query > Get Data > Blank Query > go to Advanced Editor in View Menu, Clear all that is there and paste the below code.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlDSUTJUitWJBpKYLFRZA6XYWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Class 1" = _t, #"Class 2" = _t]),
#"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type),
#"Changed Type" = Table.TransformColumnTypes(#"Added Index",{{"Class 1", Int64.Type}, {"Class 2", Int64.Type}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Index"}, "Attribute", "Value"),
#"Duplicated Column" = Table.DuplicateColumn(#"Unpivoted Other Columns", "Value", "Value - Copy"),
#"Removed Columns" = Table.RemoveColumns(#"Duplicated Column",{"Index"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Value", "Legend"}, {"Attribute", "Class"}, {"Value - Copy", "Value"}})
in
#"Renamed Columns"
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š
- ZME45 years agoRegular Visitor
Your reply was great, it helped me a lot. Thank you!