question

Lewis-3995 avatar image
0 Votes"
Lewis-3995 asked Joyzhao-MSFT commented

Microsoft SSRS 2016. Can only see 1 of 2 chart data points to amend to #PERCENT.

Hi all.

I have a chart with 2 data points, they simply report the number of rows on one of the two tables above via expression: =CountRows("DataSet1") & =CountRows("DataSet2").

My problem is, only one data point on the chart is visible. I have changed this to #PERCENT, however when I run the report and both data points become visible one of them is in percentage and the other a number. I can't see anyway to change this. Anyone had something similar?

125594-image.png


sql-server-reporting-services
image.png (37.8 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Lewis-3995 ,
Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best Regards,
Joy

0 Votes 0 ·

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @Lewis-3995 ,
I reproduced your problem. At first I had the same confusion as you.
After that, I inquired about the definition of pie chart. A pie chart is a circular statistical chart divided into several sectors, used to describe the relative relationship between volume, frequency, or percentage.
The two values you select in the "Value" area, even though you set the display as a percentage, I don’t think these two values share a whole (the whole pie chart is 100%), and the two are not in the same whole, so you It is unreasonable to choose a pie chart to display two unrelated values in the pie chart. Even if you do not use percentages, the values you get displayed in the pie chart are not visually distinguishable. In summary, you cannot compare the values of different sectors with a pie chart. This is due to the nature of the pie chart.
For your situation, I suggest you use 100% Stacked Bar.
125847-01.jpg
In my case, I use your expression, dataset 1 has 300 rows of data, dataset 2 has 5 rows of data, and the percentage information is displayed as shown in the following figure:
125848-02.jpg
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


01.jpg (3.3 KiB)
02.jpg (7.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Lewis-3995 ,
Has your issue been reslolved?

0 Votes 0 ·