Search code examples
ssrs-2012ssrs-tablix

SSRS - Create sparkline from a dataset with multiple fields in columns

I am trying to create a single sparkline from a dataset which contains multiple fields in different columns of tablix. To explain in details:

I have a tablix with 12 columns. Each column gets value from a different field in the dataset. It means that I have 12 fields in dataset and each goes to one of those 12 columns. The problem is, I am trying to create a sparkline in the 13 column for each row, however, when I create a sparkline it create 12 sparklines. However, I want one sparkline with field values from 1 to 12 months, one after the other.

I am stuck with this since 2 days. Can anyone help with this?

Solution

  • If processing time is not of an issue, try building a second data set and do a lookup for the sparkline.

    Second, you may be able to un-pivot your data and use matrix to build sparkline.

    Table on Top, Matrix below