Report Builder Chart - Filter

[bcampbell]

I'm not that great with Report Builder, and I am trying to duplicate something I had done in Power BI

I created a Chart with a standard Count of Categories

My Category list is too large for the page and I would like to break this up into just 2 charts

First Chart displaying Values with Count <= 20

Second Chart displaying Values with Count >=21

Is this created via Filter for the Chart or the Series Data Value?

[sevenhills · Accepted solution]

Two ways to do - Dataset filter, chart filter

Since you asked as chart filter, right click the chart, and chart properties, filters ... Add filter.

Copy the chart and repeat the same to modify to your needs

Tip: If the dataset is returning too many values, I recommend to split into two datasets and apply at the source query. Hope this helps!