How to show 'Expand all down one level in the hierarchy' when a user changes the filter?

[Anonymous]

I was trying to show a chart as default as "Expand all down one level in the hierarchy", like this:

But when I change the selection of the slicer from Meses(months) to Semanas(Weeks) the chart also changes to "stack" view:

What I did to be able to display this content(the slicer Months/Weeks as a dynamic slicer depending on the selection of the previous slicer) is to create a New parameter in the Modeling section and I included two columns from different tables.

After I created a measure to decide what to show on the column, the headcount by months or by weeks:

Selected HeadCount = IF ( SELECTEDVALUE (Slicer[Slicer Orden] ) = 0, [HEADCOUNT PM], [Headcount PW])

Anyone knows how to "fix" the "Expand all down one level in the hierarchy" option?

Thanks,

Hint: Maybe the error is related that while I'm changing from week selection to month selection it displays all the months for 0.5 second, like this:

But after this 0.5s it turns to stack version again:

[Anonymous · Accepted solution]

Hi @Anonymous ,

This is due to the limitation of the field parameters. Refer to the documentation, when a Field Parameter is used to swap fields in a Visual, the Visual will drop some related information like Sort direction and Drill/Expand state.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.