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.

Need Help
  • dax's avatar
    dax
    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.

3 Replies

  • dax's avatar
    dax
    Community Support
    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.

    • AyaneYep's avatar
      AyaneYep
      Helper I
      6 years ago
      The point is that I'm working with direct query, I can't create columns. Can you help me?
      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi AyaneYep , 

        If you are using direct query, I think you could try to add this column by SQL query. Or you could add this in your database, then use this in report.

        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.