Filtering visual based on hierarchy

[Anonymous]

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

[Anonymous · Accepted solution]

I was able to resolve this issue by adding one more level up. And it works.

Regards,

Yerkhan

[TomMartens]

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

[Anonymous]

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