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?
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.
I think it use count to replace sum because data type is text. It should be fine when we change data type from text to numeric. Can I check answer C?
17
0