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

[Tony88]

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=11... 

Thank you so much 

[Tony88]

@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]

@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]

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

Thanks.

[Tony88]

@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 

[rajulshah]

@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.