Showing results for 
Search instead for 
Did you mean: 
KossFrance Occasional Visitor
Occasional Visitor

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
Community Support Team

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.

Helpful resources

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 1,596 guests