Share via

Filter Dataset for multiple charts

Peter Hermansson 21 Reputation points
2021-01-19T09:26:06.483+00:00

Hello, I have a Dataset that contains sales data for multiple countries. I want to show a chart for each country. Is it possible to set some kind of filter to the chart itself, or what other ways are there except creating the Dataset multiple times?

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

0 comments

Answer accepted by question author

Olaf Helper 47,621 Reputation points
2021-01-19T10:55:26.283+00:00

Sure you can set a filter on the chart properties directly, see Add a Filter (Report Builder and SSRS): "To filter data points in a chart, you can set a filter on a category group or a series group"

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Peter Hermansson 21 Reputation points
    2021-01-19T11:43:45.993+00:00

    Sweet! Exactly what I wanted.
    Thanks Olaf!

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.