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
born2see's avatar
born2see
New Member
8 years ago

Another unfortunate soul who can't get rid of the Sum of my data.  Why does this program insist on summing these numbers???  My chart is so simple. A date field and a value field.  I just want to plot them over time but this program inisists on summing my data.  I've tried everything posted here and it just doesn't work.

 

Any thoughts before I go find some other program?

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    So, I realized my error was caused by an incorrect data read in Power Query. I had input just the YEAR into a column which was being interpretted as a Whole Number rather than a Date. When I formatted my column to a DATE, I was able to filter by YEAR and that fixed the Sum Total problem.

     

    I'd recommend taking a look at your data sets in Power Query, and making sure all your columns are formatted the way you need them to be - this will ensure it is reviewed properly.