In addition to matching or accenting the background of your main report, Filter Cards on the Filter Pane itself have a background color property. Power BI offers some ability to change Filter Pane formatting as a whole and for individual filters.Ĭolor may be an important element of your Filter Pane design. It always appears on the right side of the report canvas. While you can adjust the width of the Filter Pane, the location is not customizable. The Filter Pane is either expanded, collapsed, or hidden. 2) Filter PaneĪ second option to apply filters is Power BI’s Filter Pane. You can also modify behavior on a per-visual basis using Edit Interactions on the Format tab in the ribbon and applying changes with icons in the visual header. You have global control in the Options area to set the cross filtering or cross highlighting experience for your report viewers. Compared to cross filtering, slicers and filters applied through the Filter Pane retain their selections until a user explicitly changes the values. As soon as a user clicks elsewhere, the selection is lost and the associated filter is no longer applied. Unlike slicers and filters, however, cross filtering does not easily maintain selection state. Without any outside slicer visual or using the Filter Pane, viewers can dynamically apply filters on the page through cross filtering.

Multiple levels of cross filtering are also available by employing Ctrl + Click across more than one visual. In the case of cross highlighting, the context of the visual total is preserved but semi-transparent. Closely related is cross highlighting, which is available for a subset of visuals such as bar and column charts. Visuals respond based on a user’s selection from another visual. Let’s consider aspects of all three: 1) Cross filteringĬross filtering in Power BI provides interactivity among visuals on the page. In most situations, however, the balance of these techniques will influence your report design both from a visual perspective and from a user experience perspective. Depending on your analysis and what viewers prefer, you often work with a combination of all three. There is no correct way to choose between cross filtering, slicers, or the Filter Pane. Three important ways that designers can encourage interaction are through techniques such as cross filtering (and cross highlighting), the Filter Pane, and slicers. There are a multitude of ways that report designers may build interactivity into their reports. Instead, Power BI provides more advanced interactions that empower viewers to make meaningful selections as they explore and click on elements of a report.Īt its core, Power BI’s interactivity relies on how filters are passed (or not passed) between visuals or by outside filter selections.

Power BI does not simply rely on outside parameter selections to apply filters, which then impact how visuals render. Compared to more conventional Business Intelligence reports, such as Paginated Reports, Power BI’s report canvas can be much more dynamic. Power BI reports provide a level of interactivity for users that go beyond traditional, static reporting. After an initial description of the features available in the Power BI infrastructure, there are several examples of the visuals available for different scenarios. This article describes the available options to filter data in Power BI by using slicers and filters.

Slider slicer in excel