Forum Discussion

earlenereid's avatar
earlenereid
Frequent Visitor
9 years ago
Solved

Trend line when x-axis is text field

I would like to add a trendline to a stacked column chart.  The x-axis is a text field which displays the year/month formatted as YYYY-MM.  I am able to add a Constant line, but not a trend line.  Ex...
Need Help
  • mdannemiller's avatar
    mdannemiller
    9 years ago

    It doesnt appear that you can because power bi doesnt know how to order them chronologically.  I'd make another column which creates a date from that column 

     

    NewDate = DATE(LEFT([Date],4), RIGHT([Date],2), 1) or similar which will give you a date which is the first day of each month. 

mdannemiller's avatar
mdannemiller
Frequent Visitor
9 years ago

It doesnt appear that you can because power bi doesnt know how to order them chronologically.  I'd make another column which creates a date from that column 

 

NewDate = DATE(LEFT([Date],4), RIGHT([Date],2), 1) or similar which will give you a date which is the first day of each month. 

  • earlenereid's avatar
    earlenereid
    Frequent Visitor
    9 years ago

    I was able to create a date column to be used as my x-axis column.  With a few additional adjustments, I can now add a trend line:

     

    • Change x-axis type from Categorical to Continuous
    • Change from Stacked Column chart to Clustered Column

     

    There is a remaining issue:

     

    My x-axis is only showing labels on every other month.  How do I control that?