CODEWITHSUNDEEP
reporting-servicesdatasetssrs-2008ssrs-2008-r2
TheProgrammer
TheProgrammer

Reputation: 1344

SSRS Chart Group by Dataset

I have a chart in SSRS where I use data from two different datasets. Currently I have 2 values from dataset 1 and 2 values from dataset 2 but they are all grouped up into 1 category. Is there a way to group the data by datasets so I can display the data seperately?

Below is the table. The first row is data set 1 and the second row is data set 2 Table

This is the chart I already have. I want to bring the dataset 2 values 3.45% and 29.27% in its own group and separate it from dataset 1 data on the same axis.

Chart

Upvotes: 0

Views: 1763

Answers (1)

Daniel
Daniel

Reputation: 1364

You will see some visual differences because I'm using 2016, but the theory of the chart building is the same.

[SQL Query]

1[Chart]2

Can you confirm if this is the chart that you are trying to build?

Here is a picture of how I setup the chart properties:

Chart properties

Upvotes: 1

Related Questions