Forum Discussion

Tony88's avatar
Tony88
Icon for Helper I rankHelper I
3 years ago

How to add a dynamic average line on same axis in Power BI Line Chart?

Hello, 

 

I have a line chart with revenue by region (4 regions). I need to add a dynamic average line (not from the power bi trend line)  for all regions to the same axis. So I tried adding it, but I could not add it. It used to be easy, all you have to do is drag it to the value field, but now we have the Y axis and secondary Y axis. I could not add it.

 

Is there an easy way I can add this? Please help me out. Any help will be highly appreciated. 

 

The output result I want is below. (Red line is my average line) I don't want a dual axis.

 

This is what I got so far. 

 

Sample file 

https://drive.google.com/file/d/1PnFHbpYGvZ9DiBjlEJp38r3XhrI2NmGd/view?usp=share_link 

 

Data

https://docs.google.com/spreadsheets/d/17njhS5_ciEKPJSeJkgvemC_fi9afTh77/edit?usp=share_link&ouid=115998666847465445864&rtpof=true&sd=true 

 

Thank you so much 

 

 

Need Help
Show and Tell
Tips and Tricks

6 Replies

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Tony88 ,

     

    Please know that you can either plot the legends and one measure in Primary Y-axis OR you can have your measures in both Primary and Secondary Y-axis.

    OR 

     

    You can plot the below graph:

     

    Please let me know if this didn't help.

  • Tony88's avatar
    Tony88
    Icon for Helper I rankHelper I
    3 years ago

    rajulshah 

    Thank you so much for your response. I want all lines including the average in one line chart and on one axis. 

     

    I just try to do what you say, but it won't allow measures to add it to the Y axis tho. This is where I am having a hard time. Can you please tell me why is that? Just trying to get into a 1 chart. 

    Again, thank you 

    • rajulshah's avatar
      rajulshah
      Icon for Resident Rockstar rankResident Rockstar
      3 years ago

      Tony88 ,

       

      It's the reason as mentioned here:
      "Please know that you can either plot the legends and one measure in Primary Y-axis OR you can have your measures in both Primary and Secondary Y-axis."

      You can have either of two approaches.

      • rajulshah's avatar
        rajulshah
        Icon for Resident Rockstar rankResident Rockstar
        3 years ago

        Tony88 please mark the solution as accepted to help fellow Power BI Users.

        Thanks.