Auto Change Units in Matrix Visual

Hi There,

I had a request from a customer that when filtering down through visuals, the values shown in the Matrix only shows the Unit the visual is set to. I've found the only way to auto change is through varying Dax. Which does work but has limitations,

Would it be possible to have this as a default setting for the Matrix Visual, so options would be either set to Millions, Thousands etc etc or the Option to show Auto, so would dynamically change down, but with the added option to apply within the rows also?