Reply
Zian
New Member
Partially syndicated - Outbound

Power Bi Default Pie Chart now showing correct area

 

 

Zian_0-1596364862909.png

Above is default Power Bi pie chart. As you can see, the value is 120,810,502, which the pie chart calculates as 44.64%. However, there are two errors here,
1) The size of 120,810,502, while pie chart calculates as 44.64%, accounts for >50% of the area in terms of the pie chart, which is incorrect and misleading. Not sure whether there's something wrong with configuration or its an issue with the default chart.
2) 120,810,502, when manually calculated, is actually 42.09%, rather than the 44.64% that was automatically calculated. Again, not sure if its an error with the default chart, or my configuration.

Appreciate any help!

1 ACCEPTED SOLUTION

Syndicated - Outbound

Hi  @Zian ,

 

I should say,it's a limitation in the showing of  a pie chart,once the ID number is above 100,you will find that althought the data is changing,but the propotion in the visual seems doesnt make any difference.

Annotation 2020-08-03 163627.pngAnnotation 2020-08-03 163650.png

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

View solution in original post

7 REPLIES 7
simrantuli
Continued Contributor
Continued Contributor

Syndicated - Outbound

Hi @Zian ,

Can you share the pbix file?

 

Best Regards

Simran Tuli

Syndicated - Outbound

Please see link to sample .pbix file that illustrates the issue: https://drive.google.com/file/d/1VtqyX3Zk0vPVIqU1J_x29epNDt7HIYkk/view?usp=sharing

 

This only happens with large datasets, hence why some of the responses couldn't replicate the issue. In the sample, I showed two datasets, one is the original, the latter being the same dataset, but with some of the rows being aggregated. The latter shows the correct %, and area, while the original shows incorrect % and area seems incorrect too.


See snapshot below:

Zian_0-1596423505684.png

 

Syndicated - Outbound

Hi  @Zian ,

 

I should say,it's a limitation in the showing of  a pie chart,once the ID number is above 100,you will find that althought the data is changing,but the propotion in the visual seems doesnt make any difference.

Annotation 2020-08-03 163627.pngAnnotation 2020-08-03 163650.png

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Fowmy
Super User
Super User

Syndicated - Outbound

@Zian 

Check your measure that goes in the PIE chart and any filters applied. It is a configuration issue.
You can open a new page, insert a PIE chart, and test without any filters.

IF you could share a sample, I can check on it.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Syndicated - Outbound

How do I share a sample?

PaulDBrown
Community Champion
Community Champion

Syndicated - Outbound

@Zian 

To share a PBIX file you can upload it to  any cloud service and use the "share file" option (Onedrive, Google Drive, Dropbox, iCloud etc...)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Syndicated - Outbound

@Zian ,
As @Fowmy  recommended, start from scratch, here is demo pie chart (pretty basic) but it is showing everything correct.
So there must be something with measure/filters.

pie chart.PNG

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)