DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

By Microsoft · Question Mode

QuestionQ141

Implement and manage semantic models

You have a Microsoft Power BI semantic model that includes a table named Date. Date contains the following data.

Question Image

You need to ensure that visuals using the Date table display in chronological order while minimizing administrative effort.

What should you do?

  • A Sort the Month Number column by Column.
  • B Sort the visuals by using the Sort ascending option on Fiscal Month.
  • C Sort the Fiscal Month column by Column.
  • D Sort the Date table by Column.
Explanation

Set the Fiscal Month column to sort by the Month Number column. The numeric month values provide the chronological order for the text month names, and the model-level sort setting applies to every visual that uses Fiscal Month. Microsoft Learn documents using a month-number column to sort month names chronologically.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!