Microsoft
70-778 · Question #93
70-778 Question #93: Real Exam Question with Answer & Explanation
Sign in or unlock 70-778 to reveal the answer and full explanation for question #93. The question stem and answer options stay visible for context.
Question
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?
Options
- ADelete the query, import the data into Microsoft SQL Server, and then import the data from SQL
- BIn Query Editor, add a calculated column that totals the sales amount column.
- CChange the Data Type of sales amount column to Numeric.
- DRefresh the data model.
Unlock 70-778 to see the answer
You've previewed enough free 70-778 questions. Unlock 70-778 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.