Numeric column would not sum by category in table visual (no sigma sign shown in Fields pane)

It's possible that the data type of the field is not recognized as numeric by Power BI. To ensure that the field is recognized as numeric, you can try converting it to a number data type using the following steps:

1. Select the column in Power Query.
2. Go to the "Transform" tab in the ribbon.
3. Click on the drop-down arrow next to the data type icon in the "Any Column" group.
4. Select "Number" as the data type.

If the data type is already set to number, you can try changing the data type to a different numeric data type such as "Decimal Number" or "Whole Number" and see if that helps.

If the above steps do not resolve the issue, you can try creating a new column in Power Query using the "Number.FromText" function to convert the text values to numeric values. The formula would look something like this:

= Number.FromText([ColumnName])

Replace "ColumnName" with the name of the column containing the numeric values.

Once you have created the new column, you can replace the original column with the new column in the Power BI report.

Best regards, 

Isaac Chavarria 


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly