Forum Discussion

varit_ni's avatar
varit_ni
Frequent Visitor
10 years ago
Solved

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 ...
Need Help
  • Baskar's avatar
    Baskar
    10 years ago

    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 

elz's avatar
elz
Advocate II
10 years ago

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's avatar
    varit_ni
    Frequent Visitor
    10 years ago
    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?
    • elz's avatar
      elz
      Advocate II
      9 years ago
      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