Forum Discussion
Line chart
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
Nice, I forgot that Line charts now have drilldown!
It's not a bad idea to add that MonthSerialID column anyway though. It's very handy for doing calculations for trailing 12 months. That way you can grab the most recent 12 months, regardless of which year they're in.
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