0

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

pie chart with different values

100 percent pie chart

100 percent pie chart

aduguid
  • 3,099
  • 6
  • 18
  • 37
JuMa
  • 1
  • 1

2 Answers2

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)"

aduguid
  • 3,099
  • 6
  • 18
  • 37
  • I think this will not do it.. I want to eliminate the 0 values. But I tried the formula without the IF statement and it also does not show the 100% values. – JuMa Dec 03 '21 at 09:56
0

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..

JuMa
  • 1
  • 1