cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joemarselo
New Member

simple pie chart

Hi everyone,

I have a simple data, and want to make pie chart. But PowerBI fail to process it.

pwrbi01.png

 

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.

1 ACCEPTED SOLUTION
haozhong
Resolver I
Resolver I

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

View solution in original post

2 REPLIES 2
haozhong
Resolver I
Resolver I

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

View solution in original post

Thank you @haozhong.

that's exactly the answer.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors