Power BI Blog: Hierarchical Filters
21 May 2020
Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look a new Preview feature in Power BI, Hierarchical Filters.
Microsoft has introduced a new Preview feature to Power BI that has been long requested: ‘Hierarchical Filters’. Let’s take a look at this dataset, for example:
We’ll load this dataset into Power BI and create a hierarchy for ‘Product Type’ and ‘Sub-Category’:
Now we can create a slicer with the ‘Product Type Hierarchy’ field:
Notice that even though we have a hierarchy in this field we can only see the ‘Product Type’ field. Instead, let’s enable the Preview feature and see what happens.
After we have enabled it, the slicer changes to display the different hierarchical values within each ‘Product Type’:
We now have the ability to select the ‘Sub-Category’ within each ‘Product Type’. We can even select a combination between two different ‘Sub-Category’ values in two separate ‘Product Type’ fields, viz.