Filtering the visual Hierarchy wise

[RubanBasilea]

Hi Team

Thank for your support,

I need to filter the visuals bu hirerchy wise (we have these option in spotfire, but power bi its not working perfectly). I tried with edit iteraction options also still it refreshing the previous visual.

Need Your Help.

[amitchandak]

@RubanBasilea , In edit interaction their option to filter and fill. Have you chosen filter option.

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

[RubanBasilea]

Thank you so much This works,

Still having some issues Once i clicked any bar on the first visual its filtering the second visual , but after i clicked anything in the second visual to further  drill up for third visual , second visual is refreshed and back to original state (my case it should not reset to original position i t should be in same filtered position applied from or by first visual )

Hope you understand

Thanks

[v-xuding-msft]

Hi @RubanBasilea ,

For your first post, I think the data may be from the different tables. I created a sample and the columns are from the same table. They will be filtered for each other rather than just highlight bar.  And for the situation of filtering the 2nd visual and drilling it up, my sample don't be filtered and highlighted either. 

Anyway, it might be caused that my simple sample don't match yours. Can you please share some sample that we test ? Then we will  understand clearly and tell you if it is possible.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.