topic Re: Power BI Report Builder Not Formatting Numbers (Currency) Correctly in Report Server

Power BI Report Builder Not Formatting Numbers (Currency) Correctly

smmcqueen — Fri, 03 Jan 2025 20:03:27 GMT

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.

Re: Power BI Report Builder Not Formatting Numbers (Currency) Correctly

rohit1991 — Sat, 04 Jan 2025 10:24:01 GMT

To fix currency formatting in Power BI Report Builder:

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

This should resolve your issue.

Re: Power BI Report Builder Not Formatting Numbers (Currency) Correctly

Anonymous — Tue, 07 Jan 2025 01:48:15 GMT

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.

Re: Power BI Report Builder Not Formatting Numbers (Currency) Correctly

smmcqueen — Tue, 07 Jan 2025 15:21:45 GMT

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