Home > Sample chapters

Visuals in Power BI

Apply filters in Power BI reports

Power BI enables you to apply filters to reports to adjust what data they contain depending on your needs. The following types of filters are available:

  • Visual-level filter Suppose you have a bar chart, a pie chart, and a table in your report, and you want to filter the data only in the bar chart. In that case, you’d apply a visual-level filter to that chart.

  • Page-level filter Maybe your report has 10 pages, but you want to apply a filter to just one of those pages. In that case you could apply a page-level filter.

  • Report-level filter To apply a filter to your entire report, you use a report-level filter.

  • Drill-through filter This filter enables you to drill through the data in a report much as you would data in a visual. For example, suppose your report contains a table. You could apply the drill-through filter to that table to analyze a piece of data in that table in depth. (See screen 1 in Figure 3-10.) To return to the table, you simply click the Back button (highlighted in screen 2 of Figure 3-10).

    Figure 3-10

    Figure 3-10 Using the drill-through filter on a table in Power BI.