Forum Discussion

bullius's avatar
bullius
Icon for Helper V rankHelper V
10 years ago
Solved

Line chart with subtotals and total

Hello,   I am trying to create a line chart with three lines: Line A, Line B and the Total of Line A and B. At the moment, I can only do Line A and B OR the Total.    Is there a way of having all...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi bullius,

     

    In your scenario, I would suggest you create three measures: values for LineA, LineB and Total. Then place those three measures in chart Values property, without dragging any value to Legend property. Please refer to screenshots below:

     

    Aliqui = CALCULATE(SUM(SalesFact[Units]),Manufacturer[Manufacturer]="Aliqui")

     

    Natura = CALCULATE(SalesFact[Total Units],Manufacturer[Manufacturer]="Natura")

     

    Total = CALCULATE(SUM(SalesFact[Units]),Manufacturer[Manufacturer]="Aliqui") + CALCULATE(SUM(SalesFact[Units]),Manufacturer[Manufacturer]="Natura")

     

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

achinm45's avatar
achinm45
Icon for Advocate IV rankAdvocate IV
10 years ago

Hi bullius

What is the message it gives ? Please do let us know.

 

 

  • bullius's avatar
    bullius
    Icon for Helper V rankHelper V
    10 years ago

    It doesn't give me a message. It doesn't let me drag the measure on to the Legend field so that I have the Total as well as the two categories.

     

    When I try to add the measure to the value field, it allows me to replace "Amount", but not have both. This results in Line A and B both showing the total of Line A and B (according to the measure).

    • bullius's avatar
      bullius
      Icon for Helper V rankHelper V
      10 years ago

      I should have been clearer - it lets me create the measure, but does not let me add it to the line chart in a way that resuts in the three desired lines.