Skip to main content

Power BI

New

Add a format Parameter to the VALUE function

Vote (2) Share
Vewin Pulliam's profile image

Vewin Pulliam on 04 Aug 2022 13:50:17

Is it possible to add number formatting options to the VALUE function, similar to the FORMAT function. I can not add a metric with FORMAT function to a chart or sort a table due to the FORMAT returning a text string, would prefer more universal control over the number formatting within the metric. Adding the parameter to the VALUE function would allow for sorting and being able to use different formats in the same metric depending on layout conditions.