Forum Discussion
Report Builder Chart - Filter
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?
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!
1 Reply
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!