How to make a barchart hierarchy follow slicer hieararchy power bi?

[Anonymous]

Hi! Just as the topic foretells i am having abit of a difficulty with combining my Slicer hierarchy with my bar chart hierarchy.

Both the slicer and the bar chart uses the same hieararchy so when i select a specific level on the slicer hieararchy i want the bar chart to show exactly what i selected on that specific hieararchy level.
It now shows the correct datavalue that i have selected altough only on the first level heararchy of the bar chart. Here is an example:

When i select "Solutions" in this example it shows the correct data but at the highest hieararchy level (Affärsområde). I want the bar chart hiearchy to also change level when another level is selected in the slicer hieararchy so it would look like this:

Any help on this issue would be much obliged!

Kind Regards

D.Z

[Anonymous]

@v-stephen-msft
In your example when i select the top lvl of your bar chart and select something from the slicer, the bar chart stays at the top lvl but shows the values selected from the slicer:

[Anonymous]

Hi @Anonymous ,

It works fine on my visual. You should try to put the same hierarchy from the slicer into the bar chart. I set up like this.

When A in level2 is selected,

When A and B in level2 are selectedd,

You could check more details from my attachment.

Best Regards,

Stephen Tao

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

[Anonymous]

Hi @Anonymous!
First of all, thank you for your reply!

Unfortunately that is not what i am looking for.

I have the exact same hiearachy in the slicer and the bar chart:

In your example the bar chart shows AAA and above that the underlying alternatives.
If i choose A i just want to show A on the bar chart. If i choose A and B i want to see only those to.

So the bar chart needs to be dynamic depending on the selections of the slicer hierarchy. But it does not change level if i select a value from the let say 5th level of the slicer hiearchy.

Kind Regards