Power BI Report Builder Not Formatting Numbers (Currency) Correctly

[smmcqueen]

Greetings!

I have table visual with several number columns that I need formatted as currency with a thousands comma separator. However, I when I select the options in the quick format poriton of the ribbon, nothing happens. Furthermore, when I try to apply these options individually at the column level, the sample output is displayed correctly, but the report output is incorrect (just a number with no currency symbol or thousand separator, only a decimal). Any help is greatly appreciated.

[Anonymous · Accepted solution]

Thank you rohit1991 

Hi, @smmcqueen 

I think your column behaves as text in Report builder, so the currency symbol doesn't appear.

First, edit the expression for this column:

Format this column as currency:

Here are the results:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smmcqueen]

The issue was that it was being read as text. I wound up fixing the problem using the CInt() function.

[rohit1991]

To fix currency formatting in Power BI Report Builder:

1. Set Format in Properties: Select the column, go to Properties, and set Format to C or $#,0.00.
2. Verify Dataset: Ensure numbers are not text in the dataset.
3. Check Regional Settings: Ensure File > Options > Regional Settings match your currency format.
4. Test Output: Preview and export to confirm formatting works.

This should resolve your issue.