You have the following table.
You plan to use [Month Name] as the axis in a PivotChart.
You need to ensure that whenever [Month Name] is used in a chart, the months are displayed chronologically by default. What should you do?
A. Add a calculated column named [ID] that uses the [Month Name]&[Month Number] DAX formula
B. Change the Data Type of [Month Name] to Date
C. Sort the [Month Number] column by [Month Name]
D. Sort the [Month Name] column by [Month Number]
D is correct.
Correct is D.
Yep.