Forum Discussion
Filtering visual based on hierarchy
Hi everyone.
I have two Pie charts with same data but different hierarchy levels: I have org level 1 at pie chart 1 and org level 2 at pie chart 2.
Whn I try to filter these visuals by selections, clicking on org level on pie chart 2 works fine. However, when I select org unit, it does not select anything.
Filtering is selected in interactions.
What can be an issue?
Regards,
Yerkhan
3 Replies
Hey,
this is odd, as this will work as as you expect.
Here you will find a pbix sample file that "behaves" as expected.
Maybe you might recheck if really both pie charts are set to "filter" interaction, depending on the other pie chart. I have to admit that sometimes I mess this up, because it's sometimes not that easy to determine the corresponding menu bar of the visual.
Maybe you might consider to create a pbix file with sample file that helps us to narrow down the issue.
Regards,
Tom
Hi TomMartens
Thanks for your reply. I cant attach sample pbix, since my report has live connection to OLAP cube, and when I import required fields, it works perfectly.
So, probably issue is in OLAP.
Regards,
Yerkhan
