View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
If you want to create a column chart and have a line across the top showing the numbers in two different ways, it is easy to do in SSRS 2008. Just drag over the data into the data field twice. Right click on the data field on change the chart type to line and the other to column.
Here is a table I used to show this.
I created a Column chart and dragged over the date and numbers fields as
Notice I placed the Number data in the data field twice. Then I right
clicked on the data field and select the change chart type option. Then
selected line chart.
After I select line chart and click OK the chart looks like the image
below. It now has columns and lines on the same chart.
If you have multiple Series and only want to show for one series in the
chart you will need alter the visibility. Here is the chart with a new
columns I will use for the series.
Refresh the data set and drag over the rep to the series field.
Right Click on the data field and go to series properties...
Then set the visibility expression. Remember to set it to Not equal
to, this is setting who to hide, not who to show.
The Chart will show multiple columns and a single line.
Other posts by MikeDavis