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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

The solution needs to be dynamic - new values may be added to the field in question in the future.  Hard-coding a new value would mean manually maintaining it in the future. Not a very scalable option.

 

Confused as to why this was not built into Power BI, as this is basic functionality in excel.  The "total" value is simply the result when you remove a field from the "group by" section.  

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Any news on this? I have same issue now and I really don't want to hardcode a calculation for each series and the total.