Forum Discussion

Muzda's avatar
Muzda
Frequent Visitor
4 years ago

constant average line in a line chart

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

Tips and Tricks

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Muzda
      Frequent Visitor
      4 years ago

      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's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        4 years ago

        Hi,

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

     

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

     

    Regards,

    Nidhya

    • Muzda's avatar
      Muzda
      Frequent Visitor
      4 years ago

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