Dynamic formatting in Columns

[Nozama]

Is this possible to do in a column? (Not measure). The Result should not be formatted as text but currency.

[v-priyankata]

Hi @Nozama 

I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @Nozama 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@burakkaragoz @Sergii24 @GaloyanTelman Thanks for the inputs.
Yes as said by @burakkaragoz Power BI currently does not support dynamic formatting of numeric columns as currency based on another column, such as Currency. As the super users suggested, please follow their steps and let us know if you encounter any issues. We will be happy to assist you.

Thanks.

[burakkaragoz · Accepted solution]

Hi @Nozama ,

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.

[GaloyanTelman]

Assume you have a currency symbol in your dataset, and this code is use as a dynamic format value for the measure you want to use.

VAR BaseFormatString = "#0,0.00"
VAR CurrSymbol = SELECTEDVALUE ( Sales[Currency Code], "***")
VAR FormatString = " (" & CurrSymbol & ")" &BaseFormatString
RETURN
    FormatString

[Sergii24]

Yes, read this article to find out how 🙂
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

Good luck with your project 🙂