Forum Discussion
Solved
Line chart
I am using a line chart visual: x axis - months y axis - number of tickets I would expect my line chart display months in a chronological order Jan Feb Mar, etc.,however, the first month on my ...
1. add Month and Year columns to your table, reference to [Date] column:
Month = Sales[Date].[MonthNo]
Month Name = Sales[Date].[Month]
Year = Sales[Date].[Year]
2. sort the 'Month Name' column by 'Month'
3. use the double arrow to expand the graph to Months
So it seems that adding 2 columns to my table would be easier, would you give me an example with my case?
Not very fammiliar with DAX language yet.
1. add Month and Year columns to your table, reference to [Date] column:
Month = Sales[Date].[MonthNo]
Month Name = Sales[Date].[Month]
Year = Sales[Date].[Year]
2. sort the 'Month Name' column by 'Month'
3. use the double arrow to expand the graph to Months