Line chart

[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! 🙂

[deldersveld]

Under the X Axis in Format options, your axis should be Continuous and not Categorical. If you're using Month as its own field rather than in a date hierarchy, try adding Month from a hierarchy as well.