Multi Line chart with Dual Axis (Total)

[astorey1]

Hi

I am trying to create a multi line chart with a secondary axis and line for the total of all these meaures. I can acheive both in an individual chart but not both together which is incredibly frustrating as it takes seconds in excel! Because I am using data in my legend which spilts it into multi lines I cant seem to get a total unless I remove the legend field. 

[v-jingzhang]

Hi @astorey1 

Currently Power BI doesn't support adding multiple fields as Values in a line chart when it already has a Legend field. If it doesn't have a Legend field, then you can add multiple measures or columns into it.

If you don't have many categories in the legend field, you can add a measure for each category respectively and another measure for the total. Then put all measures into the line chart without a legend field. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@astorey1 , Not very clear. But in analytics pane you can add contsant line using measure. chekc if that can help

Secondary axis can not split line by legend in power bi as of now