Data Type Help

[Anonymous]

Hi

I am relatively new to using Power BI an have a question regarding data types and Field properties.

I have a column in my data titled 'Type' that relates to work category (e.g. Personal/Trust/Partnership).

However, when I drag the field into a Pie chart visual, it fails to recognised the inidiviuals categories and refers to a 'Count' rather than a sum of the individuals categories.

How do I go about amending the column type etc. so that the visuals can recognise each individual category?

Any help is greatly appreciated. 

[v-frfei-msft]

Hi @Anonymous ,

What is your data type of your target column? If you want to get the aggregates of the column, it should be numeric data. 

[Anonymous · Accepted solution]

I think the resources below will provide some useful insights. 

https://www.tutorialgateway.org/pie-chart-in-power-bi/

https://docs.microsoft.com/en-us/power-bi/service-aggregates

[Anonymous]

Thank you for the links provided. They proved extremely useful. 

[Anonymous]

Glad they were useful! If they were able to help you solve your problem please consider accepting it as the soution to help the other members find it more quickly.

[smpa01]

@Anonymouscan you please provide the sample data of the column called 'Type'