Forum Discussion

smmcqueen's avatar
smmcqueen
Frequent Visitor
1 year ago
Solved

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...
Power BI report builder
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

     

     

     

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

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.