Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I have a simple data, and want to make pie chart. But PowerBI fail to process it.
the table only Customer, Balance (amount), Sales (amount), and Profit (amount).
you see in 'Value' - it automatically calculates as 'Count'. I do not want to 'Count' it.
But in Excel Power View, it works perfectly.
How to correct it? What did I do wrong?
Thank you.
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |