topic Re: Have a Line Chart Ignore Parameter Selected in Report Server

Have a Line Chart Ignore Parameter Selected

Anonymous — Tue, 09 Jan 2024 21:52:43 GMT

Hello,

I am trying to achieve having a line chart that shows the average revenue of the company selected. My only issue is that the two parameters that I have on the top of the report are DATE & COMPANY. Now I want the entire page to load off of the DATE & COMPANY selected, but for the line chart. I want this to just be affected by the COMPANY selected but show all data for all dates.

Basically I am attempting to see the average of the revenue over time in this line chart, while having the rest of the report be filtered to the selected date parameter.

Any help on this would be greatly appreciated.

Re: Have a Line Chart Ignore Parameter Selected

Anonymous — Wed, 10 Jan 2024 01:40:16 GMT

Hi Anonymous ,

We can tick the box to use multiple values and get vakues from a query in available values.

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Have a Line Chart Ignore Parameter Selected

Anonymous — Wed, 10 Jan 2024 17:11:24 GMT

I see where you are going with this, my issue is that I want this parameter to only apply to a Line Chart on the paginated report. While the rest of the report works off the parameters that are visible. My knowledge is that the parameter I am creating is hidden, & only applies to the Line Chart in the Chart Properties -> Filters. Any chance you can see if you can make this work?