Display Unit based on filter

[Crydus]

Hello all, 

I have a matrix which shows the purchases our company for this year and the last year and the difference between both per customer. 
As we both need the USD amount and SQM amount of this data, I have implemented a filter which uses a simple table with one column and the two rows "USD" and "SQM". Depending on the selection of these, my measure either shows the USD values or the SQM values. (I have used the DAX expression 'SELECTEDMEASURE()' for this)

Now I have the problem, that the USD values should be shown in millions (00.00 M USD) while the SQM values should be depicted as thousands (00.0 K SQM) but inside of the field formatting I can only use one display unit or none at all, but not the "auto" unit function. Currently it is set to millions, which means that the SQM values are somewhere around 0.0x M SQM. 

Is there any way to display the values in the correct format. I have tried the 'FORMAT()' expression, but this only resulted in an error.. 

Thanks in advance for any help.

Best regards, 

Tobias

[amitchandak · Accepted solution]

@Crydus , Power bi does not support dynamic formatting.

refer if this can help

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

[Crydus]

Okay, thats is disappointing to hear.. 

I had a look into the document, but from what I can see, this wont help either.. 

But, thank you.