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

try this

Total = CALCULATE(SUM(Table[Sales]), ALL(Table[Brand Name]))
bvsaicharitha's avatar
bvsaicharitha
Helper I
7 years ago

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

  • 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