Hierarchy Slicer - Filter chart based on different level of slicer selected

[Anonymous]

I have a requirement where I have a hierarchy slicer and one visualization will display at the level selected in the slicer.  The other visualization will show 1 level below the level selected in the slicer.

For example below –

I have two slicers built from same hierarchy. If user selects plant Katowice, then one visualization will display data at the selected plant level and the second visualization should show 1 level below the selected slicer.

But In the second slicer, if area ETO is selected the first visualization should show the data for ETO and second one should show data for one level down ETO. So the chart needs to filter data dynamically based on the level selected in slicer.

Are there any suggestions around building logic for this or any workarounds.

[sarava83041]

Is there any workaround for this requirement..

[Rooban]

Is this issue still got no work arounds ?

[v-yulgu-msft]

Hi @Anonymous,

Based on my test, it is not available to achieve such an requirement.

Maybe you could use two slicers to control two visualization separately. The first visualization display data at the level selected in the first slicer. If you need to show 1 level below the selected slicer in the second visualization, please specify the next level in the second slicer.

Regards,
Yuliana Gu

[Anonymous]

Hi @v-yulgu-msft,

Thank you  but the problem is I have 5 different levels. So is there any logic that can be built with slicer to allow some sort of dynamic capability. 

[v-yulgu-msft]

Hi @Anonymous,

As if we select any value from slicer, the relative visual will show data responding to the selection. Also, if we use two slicer to control the first chart, and want the second chart to automatically drill down to next level, I'm afraid this is not supported currently.

Regards,

Yuliana Gu

[Anonymous]

@v-yulgu-msft Thanks for the update.