web
You’re offline. This is a read only version of the page.
close
Skip to main content

Power BI

New

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.