Forum Discussion
ZME4
5 years agoRegular Visitor
Bar chart in Power BI
Hello together, I have a question. I would like to draw a bar chart in Power BI which counts the values of the same type for two classes. The table looks like this: Class 1 Class 2 0 1 ...
- 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 🙂
ZME4
5 years agoRegular Visitor
I had problems to upload the diagramm, so I try it again...