Make a column not sum/count

[michaeljc70]

I've used Power BI quite a bit lately with a SSAS cube and some Sql Server queries and created many visualiations.  I am still fairly new to this though and cannot figure this out. 

I imported a very simple Excel spreadsheet. 3 columns: period, actual, goal. I tried to make a line and stacked column chart.  However, it keeps using the aggregations (that don't make sense). It is using a count of the goal and count of the actual and not the value from the spreadsheet.  

When I go into the query, I see no place to change how/if a column is summarized. I know how to do this in PowerPivot.  

Beyond that, I have no idea why it would do any aggregations since I am using all fields in the dataset and aggregation is not needed/appropriate.

When I click on the column under "Column values"  it shows "Count of Actual" and the only options are "Remove Field",  "Count (Distinct), and "Count".  How do I kjust get the value?

[alexadams78]

I think I had a similar problem - I have a list of Facebook Fans, broken down by day. As a number field, it would sum/count/average etc...but I then changed this column to a TEXT field in Power BI, and this worked - giving the options of First or Last in the values field, which was exactly what I needed.

[maracles]

@michaeljc70 if I understand you correctly you have not created a measure, you are just dragging the columns to the visualisation.

Do avoid the aggregation happening:

1. Find the field in question in the Values field of the Visualisations Pane
2. Click the small arrow to the firght of the column name
3. Click 'Don't Summarise'

Picture below, hope that helps. 

[K_Altman]

Hello,

Thank you for the reponse - it makes a ton of sense. The issue I'm experiencing is there is "Don't Summarize" option.

The options listed are:

- Sum

- Average

- Minimum

- Maximum

- Count (Distinct)

- Count

- Standard Deviation

- Variance

- Median

Thoughts? 

[michaeljc70]

Thanks for the reply. But as I said, there is no option to not summarize it. 

In doing some more research, I think the reason it is doing a count is because the column has "N/A" in some rows and it thinks it is a character field.  I transformed it to get rid of the N/As and make the column a number.  Now I see more options like Average, Minimum, etc. but no option not so summarize.

[michaeljc70]

I'll add when I put all 3 fields in a table, it looks right and there is no counts or aggregates.

[michaeljc70]

I changed the period field (so it sorts properly) and used sum on my number columns and it looks right now.  I still don't have an option to not summarize, but since it is showing the right values, I guess it is okay.