Bar chart in Power BI

[ZME4]

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!

[Fowmy · Accepted solution]

@ZME4 

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 🙂

YouTube  LinkedIn

[ZME4]

Your reply was great, it helped me a lot. Thank you!

[ZME4]

I had problems to upload the diagramm, so I try it again...