Forum Discussion

michaeljc70's avatar
michaeljc70
Advocate II
10 years ago

Make a column not sum/count

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I am also struggling with aggregation. I do not want to summarize my data, and I want to see all data points. Even after I have clicked on "Do not Summarize" in modeling tab, my data is still getting summarized. only options are count or distinct count.

 

Even year is getting counted??

 

This is weird, if I use one graph, dates work fine, but with other it doesn't. Never had this issue in tableau..

 

Please help

 date works in bar chart but not in scatter

 

alexadams78's avatar
alexadams78
Frequent Visitor
9 years ago

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.