Option do not summarize area chart

[AyaneYep]

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 · Accepted solution]

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]

The point is that I'm working with direct query, I can't create columns. Can you help me?

[dax]

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.