Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
1 like 0 dislike
10.7k views
in Power BI by 2 2 4

In Power Bi Desktop, I have a Power BI donut chart that does not show all detailed lables like this

power bi pie chart  data labels not showing

I tried many workarounds to show all data labels of Power bi Pie chart but to no avail, so

  • Why power bi pie chart data labels not showing? Is it a bug?
  • Is there away to force and show all detailed data labels of Pie chart and donut chart in Power BI?

1 Answer

2 like 0 dislike
by 56 122 250
selected by
 
Best answer

Show All detailed labels of Pie Chart in Power BI

Actually, showing detailed labels of Pie chart or donut chart mainly depends on

  • The represented data in the value and detail axis.
  • The size of the chart visual.

Below are my tries on my side, in order to investigate the behavior of showing the detail label of Pie chart in Power BI.

Case 1:

In this case, Although I have a Pie chart that shows only 3 values with sufficient size, the pie chart detail label is not showing for some items!
Actually, this normally happens if the data value is approximately the same (Low =1 and Meduim= 1). therefore, one of them will be only shown!

power bi pie chart data labels not showing

Case 2:

In this case, I'm using the same visual size and the same settings for detailed labels like fonts, position ..etc,
But when the data changed and the data value is NOT approximately the same (Low =10 and Meduim= 5) the detail labels of the pie chart are showing as expected!

power bi pie chart does not show all labels

Case 3:

In this case, I tried to decrease the visual size that leads to disappearing some of the detailed labels based on the visual size!

power bi show all data labels pie chart


Workarounds to Show All detailed labels of Pie Chart in Power BI

As per the above three cases, I approved that showing detail labels of pie chart in power bi mainly depends on the displayed data and the chart visual size.
Therefore, it's by design, you can't control the displaying of the detailed labels of the Pie chart and Donut chart as well!

However, I'll list some of the workarounds and the effective guidelines to show All data labels of Pie Chart in Power BI.

  1. Adjust Font Size.
  2. Increase Visual Size.
  3. Show Legend and only data value.
  4. Adjust Label Position.
  5. Enlarge the chart to show data
  6. Use a bar chart instead.

(1) Adjust Font Size

Try to decrease the font size of the detailed label may help in some cases!

Adjust Font Size to Display all detailed labels power bi pie chart

The Minimum supported font size is 8px

(2) Increase Visual Size

Increasing the visual size would help if you know how many items you would to show in the pie chart. otherwise, it's a useless option.

Display all detailed labels power bi pie chart

You should be aware of the pie and donut chart is suitable to show 2 or 3 values.

(3) Show Legend and only data value

To avoid the long detailed label: you should I

  • Show only data value.
  • Enable the legend.

how to show all detailed labels pie chart
Show Legend and the only data value in Power BI

(5) Adjust Label Position

Although you are showing only the data value, and maybe all labels not shown as you expect, in this case, try to

  • Set the label position to "inside"
  • Turn on "Overflow Text"

    ![Inside label position in power bi pie chart][8]
    

(5) Enlarge the chart to show data

You can also use the OOTB "Show Data" option to enlarge the pie chart. but this requires to enable the visual header option.

Enlarge pie chart in power bi - Show data

show detailed label of donut chart in power bi

(6) Use bar chart instead

As we earlier mentioned, the Pie and donut chart is suitable to display 2 or 3 values, and If you have more than 3 values, it would be preferred to use other charts like a bar chart!

use bar chart instead of a pie chart does not show the percent of the total in the tooltip in Power BI

But in Pie chart, it calculates by default the percentage of the total, and this is not available in the bar chart. in this case, as a workaround, you can show the percent of a grand total in the tooltip as shown below:

Show percent of the total as a tooltip in bar chart power bi


You might also like to read

by 2 2 4
0 0
Great explanations, thank you
If you don’t ask, the answer is always NO!
...