Column Chart/Trend Line

[Adolfo_Espinosa]

Hi,

I am trying to build a line chart that shows a trend line of sales.

Before this, I have included in my dashboard a slicer that includes "Month" dimension. This column belongs to Time table, linked to Sales table.

I would like that my line chart shows a trend line from january to the month selected in my slicer. But it only returns a dot representing total sales from the month selected.

Is it due to the DAX measure applied? or the issue comes from the axis field? In my chart, I have choiced "Month" column for Axis.

Thank you in advance for your help! 🙂

[v-piga-msft · Accepted solution]

Hi @Adolfo_Espinosa，

As I know, trend line is only support for the numeric value in X axis and you need to change the type of x-Axis to be Continuous.

Then you could create a between Slicer from month 1 to 12 and a line chart with trend line.

When you select the month filed from time table in between Slicer, the line line chart will show a trend line from january to the month you selected.

Hope this can help you!

Best Regards,

Cherry