I understand the idea but I am working with pre-defined subject areas so don't have the option to set the format during dataset creation.

Agree - this would be very helpful. If we could select the measures to which we want to apply a particular format and then format all of them at the same time (much like selecting multiple cells / rows / columns as one would do very easily in Excel) it would save a lot of time and awkwardness when constructing reports