What should you do?

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 be default.

What should you do?
A . Sort the [Month Name] column by [Month Name].
B . Change the Data Type of [Month Name] to Date.
C . Sort the [Month Name] column by [Month Number ].
D . Add a calculated column named [ID] that use the [Month Name] & [Month Number] DAX formula

View Answer

Answer: C