Scale y axis based on legend selection

[ICTJZT]

I have the following bar chart setup in PowerBI. Sum of cut is generally but not always much smaller than sum of fill. I'd like to be able to display them together but I'd also like the y axis to scale appropriately when I select just sum of cut in the legend. Is there a way to achieve this? Currently when I select sum of cut I get the below screenshot, sum of fill is greyed out but still present. Doesn't neccesarily have to be through the legend, I would be happy to have a slicer I am just not sure how to setup a slicer to pick variables to display.

[Ritaf1983 · Accepted solution]

Hi @ICTJZT 
You can use field parameters to achieve the goal ( with a slicer not from legend) if the values are 2 different measures.

Please refer to the linked tutorial:

https://www.youtube.com/watch?v=V6WchPDZibI
if it is split by category that you put on legend, just create a simple slicer with these categories as a field.

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