Crucial Exams

Microsoft Power BI Data Analyst Practice Question

A semantic model in Power BI Desktop contains a Whole number column named TransactionID. When report authors drag this field into a table visual, Power BI automatically displays a single aggregated value (Σ) instead of listing each transaction. You must modify the model so that any new visual treats TransactionID as a non-aggregated field by default, while retaining its numeric data type. Which column property should you configure, and what setting should you apply?

  • Change the Data type property from Whole number to Text.

  • Set the column's Default summarization property to Do not summarize.

  • Set the Format property to General (with no thousands separator).

  • Assign the Data category property to Identifier.

Microsoft Power BI Data Analyst
Model the Data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot