Question 230
FiscalMonth labels 'P1' through 'P12' display in alphabetical order. Which action is most appropriate for the stated business outcome?
Explanation
Correct Answer
Custom sequence keys control labels independently of lexical ordering. It meets the scenario requirement of correct fiscal period ordering.
Incorrect Answers
Formatting a ratio as percent does not require multiplying the underlying calculation by 100. It would instead address display ratio measures as percentages, not the stated correct fiscal period ordering.
Identifier fields should not be arithmetically summed. That alternative targets prevent meaningless ID arithmetic; this case requires correct fiscal period ordering.
Model formatting preserves numeric values while controlling report presentation. This solves consistent formatted currency amounts, not the requested correct fiscal period ordering.






Microsoft Power BI Data Analyst (PL-300) Practice Tests