Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

trendline issue

hi,

kindly advise on how to get the trendline for the chart below as i can find the the trendline option from the analytics panel:

kindly also note that i'm unable to find the selection option to set the x-axis to continuous as shown below:

year & monthnum are integers.

the related pbix can b found here.


apprec help to resolve this.

tks, -nik

  • Hi Anonymous,

     

    You can use bar and line chart then put the same value on the line.

    Will that meet you requirement?

2 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion

    Hi Anonymous,

     

    You can use bar and line chart then put the same value on the line.

    Will that meet you requirement?

    • Anonymous's avatar
      Anonymous
      Not applicable

      many tks, mussaenda.

      i have also switch x-axis to use date (instead of year & monthnum which are integers) to get the trendline.

       

      krgds, -nik