Occasional Visitor
Posts: 1
Registered: ‎11-21-2018

Changing Data hierarchy displayed by selecting slicer value

Hello Community,

I hope that you could support me on this topic.

I had created a hierachy as following


I built a matrice as following:


And a slicer as following:


When no value is selected it is displaying higher hierarchy level as wanted  5.JPG7

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

6 wanted.JPG8


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

Thanks for your help

Have a nice day

Kind regards

Community Support Team
Posts: 2,979
Registered: ‎02-06-2018

Re: Changing Data hierarchy displayed by selecting slicer value

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,


Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.