Line graph with summation values

Question

For the data given below and the graph attached, I need a additional line graph of the summation of mobile sales in the same graph showing the brands. Please help me. I want to see how my entire mobile sales are growing and also individual brands over time on the same line graph&nbsp;Type&nbsp;Brand Name&nbsp;Sales&nbsp;Date&nbsp;Mobile&nbsp;A1000Jan&nbsp;Mobile&nbsp;B1500Jan&nbsp;Mobile&nbsp;C2300Jan&nbsp;Mobile&nbsp;D5000Jan&nbsp;Mobile&nbsp;A1450FebMobile&nbsp;B1678FebMobile&nbsp;C1674FebMobile&nbsp;D1683Feb

stachu · Answer

try thisTotal = CALCULATE(SUM(Table[Sales]), ALL(Table[Brand Name]))

bvsaicharitha · Answer

If I create a total measure, how can i include that in the existing graph?&nbsp;

stachu · Answer

I thought that you can use multiple measures with a legend but that's not the caseyou would need to remove the Brand Name from the legend, and create set of measures per Brand, e.g.A = CALCULATE(SUM('Table'[Sales]), 'Table'[Brand Name]="A")  then you can have multiple measures in a visual, but I imagine that's lot of effort with multiple brands

bvsaicharitha · Answer

I think If I add an extra custom row with the summation of the total, then,I can use it in the graph.&nbsp; Can you help me how can i create such custom row?

v-piga-msft · Answer

Hi&nbsp;bvsaicharitha,
&nbsp;
I'm afraid that we may not add custom rows in power bi.
&nbsp;
Actually, I'm a little confused about your requirement.
&nbsp;
If it is convenient, could you share your desired output so that we could help further on it?
&nbsp;
Best&nbsp; Regards,
Cherry

Forum Discussion

Related content

prevent data summation

Fabric graph

Creating Cumulative Graphs

Count vs displaying value in graph

Summation of values in rows with same ID