Can a DAX measure's number format be changed in VBA?

[cr731]

I'm wondering if it's possible to change the number format of a DAX measure through VBA? I'd like to change how many decimals are showing based on a user's selection of a specific field.

 

[cr731]

Alternatively, if it's also possible to show numbers with the thousand separator but just show however many decimals the number has, that would work, too. For instance, if the number is rounded to zero, show 1,000. If the number is rounded to two, show 1,000.02. But to not have to change this setting in the number format of the measure, so it's dynamic.

 

[Matt Allington]

Not possible up to Excel 203. It may be possible in 2016 - not sure. There is definitely a larger VBA library, however even if it is possible, such a change will change the data model (which will require a refresh) which wont be a great user experience. There is a work around that you are read about here. It is pretty good.

Toggling Between Different Units via Slicer? - PowerPivotPro

 

[anvg]

Hi
https://msdn.microsoft.com/EN-US/library/office/mt574920.aspx
Regards,