Forum Discussion
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 |
| 1 | 1 |
| 1 | 1 |
| 0 | 1 |
| 1 | 0 |
I would like to receive the following bar chart:
How can I implement this in Power BI? Thanks a lot for your help!
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 🙂
3 Replies
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 🙂
Your reply was great, it helped me a lot. Thank you!
I had problems to upload the diagramm, so I try it again...
