Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

filtering visuals with underlying hierarchy

I'm having an issue - hope someone can help:  for data privacy purpose I need to hide smaller organizations from my visuals. All is working fine if my visualizations are only showing 1 hierarchy lev...
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

Anonymous

 

 

This is expected behavior. The filter is applied on entire visual. When you put multiple level fields, each child level is associated with the parent level fields ( if there's no relationship, it will crossjoin). So when you drill down to child level, it's already filtered. It's not possible to have the 'HC is greater than 6' filter applied on 'N-2 ' only.

 

Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you Simon  -  so you are saying there is no way / work around to get the drill down visuals respecting such common data privacy rules of excluding small teams when displaying lower levels yet showing correct (including the small teams) data if displaying higher levels. That would be a shame :-) 

    Again: thank you for your reply   and   still hoping there are possibilities mentioned by others ?!