Inserting multiple groups within the x axis

[Anonymous]

Hi is there any possible way to group multiple column fields within the x axis? I was hoping to show columns urban, rural and town where a field may contain 0 or 1

as shown in the image: image

The here is how the column works:

Urban | Rural | Town

0            1           0

1            0           0

0            0           1

So in effect, it should make 3 bars, but it only shows the value for urban 1 and 0. Hope you can help me as I'm still trying to figure out how power BI works. Thank you.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Not sure if you'd like to get below result:

You'll need to make some transformation in power query. 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlDSUTIEYgOlWJ1oKAvGM4DyDJViYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Urban " = _t, Rural = _t, Town = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Urban ", Int64.Type}, {"Rural", Int64.Type}, {"Town", Int64.Type}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value")
in
    #"Unpivoted Columns"

Pbix attached.