Forum Discussion

NickFel's avatar
NickFel
Frequent Visitor
9 years ago
Solved

Apply filter part way through visualization

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?

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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