Câu 23: 70-778: Analyzing and Visualizing Data with Microsoft Power BI

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?

1. A. Delete the query, import the data into Microsoft SQL Server, and then import the data from SQL Server.
2. B. In Query Editor, add a calculated column that totals the sales amount column. — đáp án hiện tại
3. C. Change the Data Type of sales amount column to Numeric.
4. D. Refresh the data model.