Saturday, July 15, 2023

SSRS: How to put filter at visual level

Here is the sample Sales Report which shows Region & Year wise Sales Amount.
 


If we want to put filter at tablix level then right click on tablix, go to tablix property then filter and set the filter for Year e.g 2023. Now run the report. 
 


We can see tablix level filter is working fine.

 

This advantage of report item level filter is that the information filtered out need to show in Dashboard but not required in the particular visualization.

No comments:

Post a Comment