Dynamic formatting in Columns

Great question — and you're not alone! This is a common challenge when trying to apply dynamic currency formatting in Power BI.

Here’s the deal:

Power BI doesn’t currently support dynamic formatting of numeric columns as currency based on another column (like "Currency"). Once a column is formatted as text (like your "Result" column), it loses its numeric behavior — so you can’t use it in aggregations or visuals like charts.

Workarounds you can try:

1. Use FORMAT() in a calculated column or measure

This gives you the visual formatting, but the result is text:

FormattedValue = 
SWITCH(
    TRUE(),
    Table[Currency] = "EUR", FORMAT(Table[Value], "€#,##0.00"),
    Table[Currency] = "USD", FORMAT(Table[Value], "$#,##0.00"),
    Table[Currency] = "GBP", FORMAT(Table[Value], "£#,##0.00"),
    FORMAT(Table[Value], "#,##0.00")
)

2. Use separate measures per currency

If you need to keep the values numeric (e.g., for charts), you can create separate measures like:

EUR_Value = IF(SELECTEDVALUE(Table[Currency]) = "EUR", Table[Value])

Then use conditional formatting or field parameters to switch between them.

3. Vote for dynamic format strings

Microsoft is working on improving this. You can upvote the idea here to help push it forward.

Let me know if you want help implementing one of these options in your model.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

This response was supported by AI for translation and text editing.