Option to FORMAT () values as numbers (not strings)

[clara_pantoja]

The FORMAT () function should be extremely flexible for conditionally formatting measures based on slicers and so on. But right now not even chart visuals agree with it. Please fix it? Pretty please?

[fbcideas_migusr]

Yes please, it would enhance reports a huge amount for the format on charts to work dynamically.

[mtomkowicz]

I support it, too. In MDX you can do it.

[jonathan_hu]

Can't believe this isn't supported already! I want to use a dynamic measure that switches between Sales and Units (using FORMAT to convert between "$#,##0" and "#,##0.00"). The measure works beautifully, but I lose the ability to sort the table because it is now recognized as text! Such a basic feature that is desperately needed. Please fix!

[pbiideas1]

This is definitely need. At the moment I have to create 3 additional measures for each KPI; MTD %. MTD $, MTD std

[momnewhouse2014]

Yes, in addition, in Excel, negative number like -12345 can be formatted as a bracketed number (not text) as " (12,345). After formatting negative as bracketed number, it right align with positive numbers as Excel gives a space on far right of positive number to match the closing bracket of negative number. Thanks PBI team for great work but pls PBI team help to achieve this same formatting capability as this is a basic need of any table/matrix visual otherwise it is useless.

[msoto1]

Plase add this function!

[pranav_sharma2]

By when we can expect this functionality?

[riccardo_flinto]

Would really love this as a feature. Without this, the use of dynamic metrics is limited.

[fbcideas_migusr]

I need this to plot a measure trend using the switch functionality to switch between unit types (%, currency, whole number etc). It seems to work ok for tooltips but not plotting on a chart

[pbiideas1]

Please add it, we need it asap