Which Filters and Slicers Are Supported as Sticky Filters in Microsoft Power BI Cloud?

This article describes which Power BI filters and slicers are supported as Sticky Filters in the Microsoft Power BI Cloud plugin.

PREREQUISITE:

  • 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, 7.0.2
Basic filtering + +
Advanced filtering:
  • contains, 
  • does not contain, 
  • starts with, 
  • does not start with, 
  • is, 
  • is not, 
  • is blank, 
  • is not blank, 
  • is empty, 
  • is not empty, 
  • is less than, 
  • is less than or equal to, 
  • is greater than, 
  • is greater than or equal to.
 + +
Relative time / Relative date filtering
  • is in the last, 
  • is in this, 
  • is in the next.
 + +
TopN
 - -

Supported Slicers

NOTE: If you are using a slicer that is not listed in this table, please reach out to [email protected] 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 

  • between, 
  • before, 
  • after.
 + + +

Date slicer 

  • relative date,
  • relative time.
 + + +
Hierarchy + + +
Chiclet - - -
Button - - +