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…

The correct answer is D. Add a calculated column named [ID] that use the [Month Name] & [Month Number] DAX formula. https://gasperkamensek.wordpress.com/2013/04/16/sorting-months-chronologically-and-not- alphabetically-in-a-pivot-table-report-based-on-power-pivot-data/

Model data by using Microsoft Excel

Question

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?

Exhibit

Options

ASort the [Month Name] column by [Month Name].
BChange the Data Type of [Month Name] to Date.
CSort the [Month Name] column by [Month Name].
DAdd a calculated column named [ID] that use the [Month Name] & [Month Number] DAX formula

How the community answered

(47 responses)

A
17% (8)
B
4% (2)
C
9% (4)
D
70% (33)

Explanation

https://gasperkamensek.wordpress.com/2013/04/16/sorting-months-chronologically-and-not- alphabetically-in-a-pivot-table-report-based-on-power-pivot-data/

Topics

#sort by column#month ordering#calculated column#Power Pivot

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice