Forum Discussion
Column Chart/Trend Line
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! :-)
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
1 Reply
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