Power BI Feature News — Dynamic String Format for Measures

This new feature allows dynamically format displayed values for measures in Power BI visualizations. Typically we will use it in case we would like to change format of numbers based on its value or based on currency type. This helps to keep numbers in visualizations in compact format.

As this feature is still in preview we need first to activate it in Options menu:

Then when we choose any Measure, under Menu Measure Tools we can now set new Format — Dynamic:

Now we are able to use DAX language to format Measure values based on various conditions. The static format string the measure had before switching to Dynamic will be pre-populated as a string in the DAX formula bar.

Simple scenario — condition within DAX code

Let’s say we would like to format numbers differently based on total displayed value. For this example we can use DAX function SWITCH: