Dynamically change measure's format in visual (line chart) using switch?

[sublog]

I have a line chart that I am using a switch statement to select two different groups of measures. One is a whole number and the other is in currency. 

Is there a way to have the chart automatically change to currency when a measure is selected that should be in currency and switch back? 

Here's my measure. 

Select =
IF (
HASONEVALUE ( _Daily[Sort] ),
SWITCH ( VALUES ( _Daily[Sort] ), 1, ( [Orders $] ), 2, [Orders #] )
)

[v-chuncz-msft · Accepted solution]

@sublog 

Format cannot be changed in a DAX measure. But you may drag both measures to Values and let one of the two return BLANK () based on the selection.

[Quiny_Harl]

Would you mind explaining a bit more what you mean by this? How do I make one of the two measures return blank(), when the other is selected? 

[mahoneypat]

Use the FORMAT() function like this

Format Test = var tempsum = SUM('Table 2'[Value])

return if(tempsum>5, FORMAT(tempsum, "Currency"), FORMAT(tempsum, "Percent"))

You can adapt for your measures.  There are pre-defined ones (like above or you can do custom).

 https://docs.microsoft.com/en-us/dax/pre-defined-numeric-formats-for-the-format-function

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

Regards,

Pat

[sublog]

I tried this, but I can't figure out how to make it show in the line chart visual. It won't even allow me to move the measure to the Values.