Forum Discussion
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.
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
7 Replies
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
Thanks Baskar. Sadly, some values there are critical. Will use Card to display them instead.
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?
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
- 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
