BenchMark Quizzes by MDFT Pro

Sort Month Names Chronologically In Power BI Visuals

You are working on a Power BI report at MDFT Pro that displays months in alphabetical order in a visual. For accurate analysis, you need the months to appear in chronological order (January, February, etc.).

How can you show the month names in chronological order in your visual? Choose the best option.

Choose the correct answer from the options below.

Explanations for each answer:

Add the Month Number column to the X-axis for the visual above the Month column. is incorrect. This will display month numbers on the x-axis of the visual, not month names.
Select the visual, select More Options and change the Sort by option. is incorrect. The Sort By option only allows sorting by columns that are used in the visual.
Select Month in the Field list and set Sort By Column to Month Number. is correct. Sort by column allows you to sort month names chronologically using the Month Number column.
Add an Order By to the query for the dataset to sort by TimeStamp. is incorrect. The order of the data in the dataset does not affect the x-axis order in the visual.
Add the Month Number column to the Filters on this visual. is incorrect. Adding a column to a filter does not change the sort order of the x-axis of the visual.

Learn more about sorting visuals in Power BI:

Power BI Sort by Column

Exam Preparation Quiz

Sort Month Names Chronologically In Power BI Visuals