Forum Discussion

astorey1's avatar
astorey1
Frequent Visitor
4 years ago

Multi Line chart with Dual Axis (Total)

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. 

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    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.