SSRS Chart Filtering

e10

(Jarrad Layne) #1

Hello All,

I have an SSRS question related to charts, specifically bar/column charts. I have made a vendor performance report where I’m charting late deliveries. Receipt Date vs PO Rel Due Date by vendor (Details section) then grouped by vendor group, the chart is in the vendor group footer. I’m able to get the values to chart, each bar in the graph showing the percentage of shipments that were late from that vendor, however I only want to see the vendors that have some late shipments in my chart, so a bar in the graph over zero percent. I want to suppress any bars/columns in the graph that are zero percent. When I look at the Series properties -> Visibility it seem to affect the entire series. Suppressing all of my bars/columns. If try to make a separate data set filtering out shipments that aren’t late then all my bars/columns are at 100% because I’m only pulling in late shipments. So I’m wondering if there is any way to filter these specific data points out of my graph?

My only other thought is to create a sub query in my BAQ that looks to see if the Vendor has any late shipments then have a calculated Boolean field that would be used to filter on that level to only allow vendors that have had some late shipments at some point, but I don’t feel like that would easily introduced into my baq and overly complicated for something that seems like it should be a configurable setting in the chart… but I’m starting to think there is no other way. Any help is appreciated.

Thanks for reading.


(Alejandro Cortes) #2

Hello my friend, I struggled with this as well. You need to look under Category Group Properties. See below image, I used it to filter top 10 scrap offenders


In the expression, you can enter whatever calculation you want, but be sure to use either sum or avg if not it will not work.

in the operator select the Top N and in value you can put a number like me or a function.

Hope this helps!


(Jarrad Layne) #3

Thank you, yes this worked. I thought i looked through that properties screen, but I was focusing on finding visibility property instead of a filter, Either way thanks for the info it worked perfectly.


(Alejandro Cortes) #4

Awesome!

Glad to be able to help!