Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
varit_ni
Frequent Visitor

Missing some values in Pie Chart

I create a pie chart indicating % of Market Value per NAV. However, the chart doesn't dispaly all possible values.
For instance, in below case 3 values are missing.

Please suggest how to display all.

 

Capture.JPG

1 ACCEPTED SOLUTION
Baskar
Resident Rockstar
Resident Rockstar

Hi varit,

 

This is default nature of Pie chart in Power BI. It will doesn't show the most least value in visual.

 

That we cant do anything on here 

View solution in original post

7 REPLIES 7
elz
Advocate II
Advocate II

This is interesting, because I created a pie chart whose data source had negative values. None of the negative values appeared on the chart, even though there were only 5 or 6 values displayed on the chart.

 

I wonder if the reason the negative numbers were not displayed is because they were the lowest values to be displayed on the chart?

 

Tracy

varit_ni
Frequent Visitor

Hi Tracy. Believe that you need to have only positive value to display on the chart. How about you use ABS(neg_no). Would that work?

hi varit,

yes, pie charts only display positive values. i just changed the chart type to a stacked column chart, so that the negative values could be displayed.

tracy
Baskar
Resident Rockstar
Resident Rockstar

Hi varit,

 

This is default nature of Pie chart in Power BI. It will doesn't show the most least value in visual.

 

That we cant do anything on here 

Currently it my pie chart is not showing labels for values in the middle of the data... Why would the labels excludes values in the middle of my data set rather than leave off the last 2-3? 

Anonymous
Not applicable

Why were there so many bugs in Power BI even after the updated version was released this Aug? This never happens in anyother BI tool.

Thanks Baskar. Sadly, some values there are critical. Will use Card to display them instead.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.