dynamic format strings for measures in powerbi

 Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

Dynamic format strings overcome an inherent disadvantage of using the FORMAT function. That is, with FORMAT even numeric data types are returned as a string, which may not work with visuals that require numeric values, like charts. When using dynamic format strings, the measure keeps its data type and isn't forced to change to a string data type. This applies different format strings to the measure depending on the context.