Forum Discussion
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 ...
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.
I'll add when I put all 3 fields in a table, it looks right and there is no counts or aggregates.
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.