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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
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

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

    That solution works. Thank you!

    • wildmight2017's avatar
      wildmight2017
      Icon for Advocate II rankAdvocate II
      8 years ago

      Sorry to re-animate old topic - but I'm having the same issue and proposed solution does not work (as it's not practical once you hit more than 5-6 categories). Is there an easier way to bring Total line to the line chart? Thank you! 

  • shishir999's avatar
    shishir999
    Icon for Helper II rankHelper II
    8 years ago
    Hi, In Line chart, I am able to calculate the Total. But in my scenario, there are 3 Status (Success, Failure, In-Progress) in filter. S=5, F=3, IP = 2 ; Total=10 Once, I filter the status (Success), the user want to see the status =5 for the "SUCCESS" and the Total of ALL Status=10. But, it is only calculating status=5. *********** CALCULATE(COUNTROWS(ALL_Record), Filter((ALL_Record), ALL_Record[Build_Date] <= MAX(Build_Type[Date]) )) ************* Could someone, please help in this. Shishir