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, bu...
Need Help
Show and Tell
Tips and Tricks
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.

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

        rajulshah 

        I was able to do this wit this DaX. So I can not accept your answer. I will post it later. Thank you so much for your input