Forum Discussion

bvsaicharitha's avatar
bvsaicharitha
Helper I
7 years ago

Line graph with summation values

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 ...
Need Help
Tips and Tricks
Stachu's avatar
Stachu
Community Champion
7 years ago

I thought that you can use multiple measures with a legend but that's not the case
you 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's avatar
bvsaicharitha
Helper I
7 years ago

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

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi bvsaicharitha,

     

    I'm afraid that we may not add custom rows in power bi.

     

    Actually, I'm a little confused about your requirement.

     

    If it is convenient, could you share your desired output so that we could help further on it?

     

    Best  Regards,

    Cherry

    • bvsaicharitha's avatar
      bvsaicharitha
      Helper I
      7 years ago

      Hi,

       

      This is the similar output that I am interested .

       

      Example ,the top green one is the summation of all the brand sales and the rest colors are the individual brands . Ideally, when I create the line graph, I will only get the individual ones by setting legend. I am interested to see the total as well in the same graph. Now the green  graph is total of all sales over period