constant average line in a line chart

[Muzda]

Hi,

I have a little problem. How to put constant average line for the last 3 months, 6 months and a year (separately) in a line chart that shows no of users((y-axis) ) per day(x-axis) and month as a legend. I have already calculated the measure of those averages but when I try to drag them in a line chart, it doesn't work.They sit in Tooltips instead of Value, even if I force them to be in Values. Untill I removed the month in a legend fields, which I don't want to do. 

Any help to solve this?

I want those constant lines to be shown as in this figure 👇

Thanks

[Anonymous]

Hi,

Try to add Average Line with measure that you created. Hope it will solve this,

Regards,

Nidhya

[Muzda]

Thanks for the suggestion. I tried but it didnt work. It work only when I put constant value.

[amitchandak]

@Muzda , In the new version analytics pane, the constant line has the option to use a measure using fx.

See if that can help

[Muzda]

Hi, 

Thank you so much for the answer. I have tried to put measure but it does not seem to work . If I put constant number it takes the number but when I use fx it doesn't.

So the problem still persist.

[Ashish_Mathur]

Hi,

Can you share the download link of your PBI file.  Please show the problem there clearly.