Scaling Y Axis based on Highlighted Values

[Chaucer]

I've got a column chart that I'm filtering based on a line selected in a matrix:

Is there any way to scale the Y axis of that graph so that it reduces to make the highlighted numbers more relevant? In some cases the values reported are going to be very small relative to the original data, and I'd really like to be able to see those filtered values clearly.

Thanks

[vanessafvg · Accepted solution]

you need to edit interactions, so that it filters it completely, this will allow you to only see the numbers you filtered.

look on the format menu for edit interactions

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[mahoneypat · Accepted solution]

You can use the Edit Interactions features to change it so your visuals crossfilter each other instead of crosshighlighting (like you have shown).  Please see this link.  You can also make that behavior the default in your options (recommended).

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[vanessafvg · Accepted solution]

you need to edit interactions, so that it filters it completely, this will allow you to only see the numbers you filtered.

look on the format menu for edit interactions

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions