When I’m creating or modifying a measure, I don’t always get the number format right the first time (shocking, I know.) I’ve lost count of how many times I’ve used inappropriate language in the workplace after the following sequence of events:
• Select Currency, change decimals to 0, select no symbol… doh! Decimals have been reset to 2!
• Do the muscle memory thing of Currency, no symbol, 0 decimals, then realize it should be a different format. Click Number… it’s reset to 2 decimals again!
It's small, but it’s really irritating. It would be awesome if a selection change checked the number in the decimal box to see if it is a valid selection and preserve it if so.
I know it’s still early in the PowerPivot life cycle, and I completely understand why these things are the way they are (bigger fish to fry and all.) The reason I bring it up though, is that building with PowerPivot is an extremely slow process today. Everything we do seems to cause a full measure recalculation which takes a significant amount of time. Little things like this just feel like they add insult to injury as you have to keep re-applying them, slowing you down even more. It certainly doesn’t affect my ability to do anything or create a solution, it just makes it a more frustrating experience.
(This is PowerPivot in Excel 2013)