Changing Data hierarchy displayed by selecting slicer value

[KossFrance]

Hello Community,

I hope that you could support me on this topic.

I had created a hierachy as following

12

I built a matrice as following:

43

And a slicer as following:

56

When no value is selected it is displaying higher hierarchy level as wanted  7

But When I select a value, the previous screeshop filtered is displayed whe I would like that the next hierarchy level related to the hiigher level selected within the slicer appears as following

8

 Does a solution exist to do it without touching to arrows to drilldown?

Thanks for your help

Have a nice day

Kind regards

[v-piga-msft]

Hi @KossFrance,

If I understand your requirement correctly that you want to show the filtered value of Lvl 2 directly when you select in a slicer for Lvl 1?

If it is, I'm afraid that we may not achieve that in Power BI currently. 

You could sumbit you idea in Power BI ideas Forum.

Best Regards,

Cherry