Power BI filters are a powerful way to refine the data visualizations you share on your screens. This guide will walk you through the process of applying filters so that your ScreenCloud Microsoft Power BI app displays the information that matters most.

This should be the name of the table in the dataset and needs to match exactly what is in the report’s Dataset

This should be the name of the column name in the dataset and needs to match exactly what is in the report’s Dataset

In: keeps records if the column is in the list provided. The value(s) can be a single value or a comma separated list of values

NotIn: keeps records if the column is NOT in the list provided. The value(s) can be a single value or a comma separated list of values

All: this should force the report filter to override any other filters and force all records to be returned

This is a string representation of the value (or list of values supplied in CSV format).

For a singular value you can also use the following prefixes to force the value to be treated as either a numeric or boolean values which allows for proper filtering on columns of those types.

Numeric: supply a prefix of N:: so the value should be N::596 if you want to filter on a numeric column

Boolean: supply a prefix of B:: so the value should be B::true or B::false if you want to filter on a boolean column

To pull screen data (Screen > Settings > Advanced Settings > Data) into a value, you need to provide the key inside curly braces like so: {key}. You can also still use the numeric and boolean prefixes as well where needed. So, for this example we could set a filter up where the value would take the following format, {location}.

Advanced filters get added in the format below:

{TABLE_NAME}/{COLUMN_NAME} {OPERATOR} ‘{FILTER_VALUE}’

A simple example would be:

TABLE_NAME: “Sales”

COLUMN_NAME: “Month”

OPERATOR = “eq” FILTER_VALUE: “Jan”

Which would require a filter:

There are some escape characters that need to be taken into consideration when there are things like spaces, slashes or a full stop/period.

You need to make the following substitutions with their unicode counterparts (there may be more but these seem like the most likely to be used in table/column names):

Space “ “ replace with “x0020”

Slash “/“ replace with “x002F”

Period “.” replace with “x002E”

A more advanced example based loosely on an issue seen recently in a customer account:

TABLE_NAME: “Sales Month End”

COLUMN_NAME: “Month End / Acc. Id”

OPERATOR = “eq”

FILTER_VALUE: “ABC123”

This needs a filter as follows:

Reference: