How to dynamically adapt the y-axis depending on a filter

[Olifer]

Dear Power BI community,

I have set up a stacked column chart as shown in pic1 (on the left). When I filter for certain values in another chart, it changes to what's shown in pic2 (on the right).

As you see, pic2 still shows the original values in light orange in the background and the newly filtered values in darker orange in the front. Since the filtered values are quite small, I would like the original values not to be shown in the background but only show the filtered ones. Additionally, the y-axis should then adapt automatically to the filtered values.

Is there a way in Power BI to achieve this? I'd be greatful for any hints.

Original valuesOriginal (light orange) and filtered (dark orange) values

Thanks a lot and best regards
Oliver

[Olifer]

This did the trick - thanks a lot for poining me to that video. I was not aware of Filter Interactions up to now.

Best regards

Oliver

[amitchandak · Accepted solution]

@Olifer , Change interactions to filter

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4