Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Hi @PeteSil1020 ,
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.
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?