Forum Discussion
How to dynamically adapt the y-axis depending on a filter
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 , Change interactions to filter
How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4
2 Replies
- amitchandak
Super User
Olifer , Change interactions to filter
How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4
- OliferFrequent Visitor
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