question

markgoldin-3750 avatar image
0 Votes"
markgoldin-3750 asked Zolotoy-3922 commented

SSRS reprot chart idea

I need to replicate the following chart in a report:

93669-image.png


The way I see it it is a line chart with markers and a tiny vertical column chart. Is it possible to do it?



Thanks


sql-server-reporting-services
image.png (55.2 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 @markgoldin-3750
Has your issue been resolved?
If the answer is helpful, please click "Accept Answer" and upvote it. Thanks for understanding.
Best Regards,
Joy

0 Votes 0 ·

1 Answer

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

Hi @markgoldin-3750 ,
Unfortunately, specific markers are not supported in the report.
SSRS supports combined chart types. In other words, we could use different types of charts (such as bar charts and line charts) in the same chart. You could display different digital scales through the auxiliary axis.
The creation of a specific chart needs to be based on Values, the fields of Category Groups and Series Groups.
Hope this helps.
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.


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

Can I have more than two charts on the same chart area? Can these markers be another cluster chart?

0 Votes 0 ·

There can be more than two charts in the same chart area, depending on the fields in the data placement area. Regarding these markers to generate cluster charts, unless these values are included in the Dataset, then you can choose scatter charts in the chart type.


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.

0 Votes 0 ·

I was able t show these markers conditionally. That the key of making it work.

0 Votes 0 ·

Yes, I will respect your decision. If it really helps you, please help and mark it as "Accept Answer" so that more people can refer to it.
Thank you.

0 Votes 0 ·