How do I set Power BI filters or parameters in PBRS?

Power BI filters are set in the Report Filters Wizard which appears as a step during the creation of a schedule, or in the properties screen of an existing schedule.

Report Filters Wizard

10-9-2019 10-26-53 AM
  • In this section, you will determine the filters for your report (if any). If your report has Power BI and SSRS Reports: Report Filters  in PBRS.no filters, you may skip this section by clicking next.
  • You can type a value into the field, or drag and drop an "insert".
  • Preview: View the dashboard/report output given the selected filters.
  • Filter Type: You may choose between Basic Filter or Advanced Filter.
  • Filter using this field (Table.column): Choose the table and column you would like to set up the filter.

Filtering With Basic Filter

  • Use basic filtering to add specific values in the report.
  • You can also filter values passed in as pipe-delimited to be converted to multi-values.
Example: value1 | value2

This will only work in Basic Filter type.

  • Show items when the value matches (Basic Filter): Insert the value you would like to add and then click Add.
Power BI and SSRS Reports: Report Filters  in PBRS.

Filtering with Advanced Filter

  • Use the advanced filter to add values between values ranges. 
  • Show Items when the value (Advanced Filter): In this option, you have the option to show items when the value and select the option from the drop-down menu.
Power BI and SSRS Reports: Report Filters  in PBRS.
Power BI and SSRS Reports: Report Filters  in PBRS.
  • You can use the Calendar icon to select the specific date.

This option will be enabled if you selected Date as the Field data type.

Power BI and SSRS Reports: Report Filters  in PBRS.
  • Once you finish, click Save Filter to save the filter.