Forum Discussion
simple pie chart
1. Go to the table underlying the pie chart and click on the "Balance_LCY" column
2. Click on "Modeling" at the ribbon above
3. In the "Formatting", choose "Whole Number", "Decimal Number" or "Fixed Decimal"
4. Then you will prompt a windows message saying changing data type will etc etc. Click on Yes.
5. Then on the pie chart - Values. You can now select "Sum"
The reason you only get Count is because your data type for that particular column is text. That's why Power Bi can't add the values.
- Hao Zhong
1. Go to the table underlying the pie chart and click on the "Balance_LCY" column
2. Click on "Modeling" at the ribbon above
3. In the "Formatting", choose "Whole Number", "Decimal Number" or "Fixed Decimal"
4. Then you will prompt a windows message saying changing data type will etc etc. Click on Yes.
5. Then on the pie chart - Values. You can now select "Sum"
The reason you only get Count is because your data type for that particular column is text. That's why Power Bi can't add the values.
- Hao Zhong
Thank you haozhong.
that's exactly the answer.