Analyzing and Visualizing Data with Microsoft Power BI — Question 18

You are importing sales data from a Microsoft Excel file named Sales.xlsx into Power BI Desktop.
You need to create a bar chart showing the total sales amount by region.
When you create the bar chart, the regions appear as expected, but the sales amount value displays the count of sales amount instead of the sum of sales amount each region.
You need to modify the query to ensure that the data appears correctly.
What should you do?

Answer options

• A. Delete the query, import the data into Microsoft SQL Server, and then import the data from SQL Server.
• B. In Query Editor, add a calculated column that totals the sales amount column.
• C. Change the Data Type of sales amount column to Numeric.
• D. Refresh the data model.

Correct answer: B

Explanation

The correct answer is B because adding a calculated column in Query Editor allows you to aggregate the sales amounts correctly. Option A is not necessary as importing into SQL Server does not directly solve the issue. Option C may help if the data type is incorrect, but it does not address the aggregation problem. Option D simply refreshes the data model without modifying how the sales amounts are calculated.