Forum Discussion
Power BI Report Builder Not Formatting Numbers (Currency) Correctly
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.
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.
3 Replies
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.
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.
The issue was that it was being read as text. I wound up fixing the problem using the CInt() function.
