This article describes which Power BI filters and slicers are supported as Sticky Filters in the Microsoft Power BI Cloud plugin.
PREREQUISITE:
- v7.2.1+: Set ENABLE_STICKY_FILTERS System Variable to 'Y'.
- Prior to v7.2.1: Set ENABLE_POWERBI_STICKY_FILTERS System Variable to 'Y'.
Table of contents:
Supported Filter and Slicer Levels
| Filter and Slicer Level | v6.4.5 | v7.0.1 | v7.0.2+ |
|---|---|---|---|
| Filters on this page | + | + | + |
| Filters on this visual | -* | - | + |
| Filters on all pages | -* | - | + |
* Support for Filters on this visual and Filters on all pages is available via a patch in v6.4.5.
Supported Filters
| Filter/Slicer Type | v6.4.5 | v7.0.1+ |
|---|---|---|
| Basic filtering | + | + |
Advanced filtering:
| + | + |
Relative time / Relative date filtering
| + | + |
| TopN | - | - |
Supported Slicers
NOTE: If you are using a slicer that is not listed in this table, please reach out to support@metricinsights.com to confirm compatibility. While this table does not cover every slicer type, additional slicers may still be supported.
| Slicer Type | v6.4.5 | v7.0.1 | v7.0.2+ |
|---|---|---|---|
| Categorical | + | + | + |
Range
| + | + | + |
Date slicer
| + | + | + |
| Hierarchy | + | + | + |
| Chiclet | - | - | - |
| Button | - | - | + |