Forum Discussion

michaeljc70's avatar
michaeljc70
Icon for Advocate II rankAdvocate 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
michaeljc70's avatar
michaeljc70
Icon for Advocate II rankAdvocate II
10 years ago

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

michaeljc70's avatar
michaeljc70
Icon for Advocate II rankAdvocate II
10 years ago

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.