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 ...
You need to go back to the table/query click on the dots to the right and select edit query
When the data list is displayed, find the column that you want to sum. right click on the column title to select the column and display the menu, then select "change type" and select the appropriate type such as "decimal number"
Click the "Close and Apply" button to update the query.
Now when you click on the field in the "Values" section you should have all the options
This helped on some columns that were marked number and when I switched t it to text, it removed the sum. Thanks. However not working on all of my columns.