Forum Discussion

Olifer's avatar
Olifer
Frequent Visitor
3 years ago
Solved

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

2 Replies

  • Olifer's avatar
    Olifer
    Frequent 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