Matrix visual with a hierarchy should filter a pie chart visual with the same matrix

Hello everyone, I have the following problem:

I have a matrix visual with a hierarchy and a pie chart with the same hierarchy. I want to achieve, that if I am selecting a Level/Value in the hierarchy, that I can see in the pie chart the selected Level of the hierarchy +1.

The matrix looks like following:

The visuals look like the following:

This is how it should look like:

I know that it works with the "Go to the next level in the hierarchy (button)" but this is not a good user experience and some of the users will not understand how it works correctly. That’s why I want to automate the Level selection.

My idea was to write a Measure that gives you the selected Value. With the following Measure I am able to get that.

Selected Level =

VAR A =

IF (

ISFILTERED ( Tabelle1[Level3] )

&& MAX ( Tabelle1[Level3] ) <> BLANK (),

3,

IF (

ISFILTERED ( Tabelle1[Level2] )

&& MAX ( Tabelle1[Level2] ) <> BLANK (),

2,

IF (

ISFILTERED ( Tabelle1[Level2] ),

MAX ( Tabelle1[Level2] ),1

)))

Return

A

 

Afterwords the idea was to write another measure that gives you the Selected Level +1 in the Visual. For example if Level2 is selected in the Matrix just show the Level3 values in the pie Chart

 

Therefore my idea was to write a measure which is just showing the selected Level +1 in the visual. But unfortunately I am not able to write a measure that gives me just the number of the selected hierarchy Level.

I hope somone can help me out.

Here is the link to the sample file

https://hubstersde-my.sharepoint.com/:u:/g/personal/peter_schmaeling_hubsters_de/ETnbvYnadRxEvlHbUcNzEDMBvIAbJeAflabL3qSTqglLsA?e=OyeuG6