Forum Discussion

AyaneYep's avatar
AyaneYep
Helper I
6 years ago
Solved

Option do not summarize area chart

I would like the powerbi not to group the products, and show without summarizing in the graph, just as it is in the table.
  • dax's avatar
    6 years ago

    Hi  AyaneYep , 

    If you don't want to summarize, I think you need to create an index column like below

    let
        Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlTSUTJUitWBsIzgLBMwKwnIMoWzjOEsiLpkuN5kuDooKxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [name = _t, amount = _t]),
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"name", type text}, {"amount", Int64.Type}}),
        #"Grouped Rows" = Table.Group(#"Changed Type", {"name"}, {{"all", each _, type table [name=text, amount=number]}}),
        #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([all], "index",1,1)),
        #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"all"}),
        #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"amount", "index"}, {"amount", "index"})
    in
        #"Expanded Custom"

    Then design chart like below

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.