Question

You have a Microsoft Excel file named Enrollments.csv that contains data about Student Enrollments by Region.After you have imported the Excel file to Power BI Desktop, you create a bar chart showing the Enrollments amount by region.Unfortunately, the Enrollments amount value appears as the count of Enrollments amount instead of the sum of Enrollments amount for each region.You need to modify the query to ensure that the data appears correctly.How can you fix the issue?

Answer 1

To fix the bar chart in Power BI Desktop, ensure the Enrollments amount field is set to a numerical data type and change its aggregation in the 'Values' area of the bar chart from Count to Sum.

Step-by-step explanation:

If you’re experiencing an issue where your Power BI Desktop bar chart displays the count of enrollment amounts instead of the sum by region, you can correct this in a few steps. First, make sure your Enrollments amount field is set to the correct data type, such as a number or currency, if it’s not already. Then, after importing the Enrollments.csv file into Power BI Desktop, go to the 'Fields' pane. Select the Enrollments amount field and drag it into the 'Values' area of your bar chart. Once it's in the 'Values' area, click on the dropdown arrow next to the Enrollments amount and ensure that the aggregation type is set to Sum instead of Count. This action will change the bar chart to display the total sum of enrollments by region.