SSRS no data label for 100% chart

Question

I have created a SSRS 2017 report with a pie chart. The dataset returns the number of 3 different values/sections (total "green", total "yellow", total "red").

Now I want to show the data labels (-> pictures). I switched to line-chart, added the formula e.g.

= IIf(Fields!red.Value=0, "", "#PERCENT"+ chr(10)+ "(#VALY)")

to each line/section.

It works fine (-> picture 1) but e.g. for the case when I have 2 zero sections and only 1 section with 100%, the data labels are not shown. For each value > 0 < 100 the data labels are visible.

I also tried it without the formula/default values but the problem also occurs.

Does anyone know the issue?

Thx in advance for your replies!!

Pie chart with different values

100 percent pie chart

Answer 1

It looks like all you need to do is update the expression. It would also depend on how you have the series label data setup.

= "#PERCENT"+ chr(10)+ "(#VALY)"

Answer 2

Query for data

I use this simple Query as data set. So aggregations are done via SQL Query, not by SSRS.

All I want is that the 96 green data/100% are visible as label on the diagram, but it doesn't work...

The problem also occurs for line diagram, so it has nothing to do with the pie chart..