Better go with calculation. We can create calculation to customise more formatting things here.
I think there is no direct workaround here.
This is what you are looking for.
Here is one approach. This is a Dimension though because we are adding the unit string. You can use the real measure to draw the marks and label everything with the calc.
eg. say you want to show 1,234,567.89 in thousands or millions
Custom format: 0,0.00,K
will appear as 1,234.57K
Custom format: 0,0.00,,M
will appear as 1.23M