Skip to main content

Power BI

Needs Votes

Use values produced by table function in visual level filters

Vote (1) Share
Adam K's profile image

Adam K on 25 Jan 2020 07:20:02

We should be able to write a measure that produces a one-column list of values, and then use that list of values to filter a visual.

Example: After adding a column to a visual level filter, one of the options in the "Show items when the value:" drop-down menu should be "is in" - once that is selected, we could identify a measure that produces a list of values to filter the visual.

Similar to using a subquery with an IN operator in the WHERE clause of a SQL statement.

This would drastically improve the flexibility of visual level filters.