Skip to main content

Power BI

Needs Votes

Filtering in Matrix with Drilldown - filter based on current view hierarchy

Vote (6) Share
Ryan Fonash's profile image

Ryan Fonash on 20 Apr 2017 22:05:43

In a matrix with drilldowns, setting visual filter options affects the data that is being shown at the deepest level. I would love to have the filter act on data at the smallest level of the hierarchy currently being viewed.

For example, if my row hierarchy is:
Category/Subcategory/Product

And i set a visual filter where Sales > 5,000

If I am only viewing at the Category level, it should filter based off of total sales for each category. If I am viewing subcategory as the deepest level, it woudl filter where subcategory sales are > 5000.

Currently, regardless of what level of the hierarchy you are viewing, it will filter at the deepest level. For example, if I am viewing only Category, and I set the filter to Sales > 5000, it will only show me categories that have a PRODUCT that has sales > 5000. This is slightly misleading and confusing.