Apply filter part way through visualization

[NickFel]

So I have a dataset where all items have an iteration associated with them.

There are 4 hierarchial levels in the data set and I want to show the all of the top 3 hierarchies all the time, and show ONLY filter the 4th hierarchy based on iteration. 

The issue is that the iteration field is common across all hierarchy levels, so once I apply the iteration filter it filters out any of the top 3 that might not match that filter (common as these are longer term goals).

Any thoughts?

[v-shex-msft · Accepted solution]

HI @NickFel,

For your requirement, I think you can split your 4th level hierarchy column and use it to a new table, build relationship between new table and 4th level, use new table column as the source of slicer to filter your data.

Regards,

Xiaoxin Sheng