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 ...
I have been fighting this as well. It makes a difference which visualization you are adding the values to. I show the "Don't Summarize" option on the Table, but not the Line Chart.
Don't summarize in tablesNo choice in Line Chart
I've manged to get the SUM menu option to appear by simply formatting the columns in your orginal data file (i.e. excel or SQL) to be decimal format type. Once this is done, re import the data table to power BI and the SUM menu option should appear. Hope that helps.