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.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
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.

 

 

 

 

  • smmcqueen's avatar
    smmcqueen
    Frequent Visitor
    1 year ago

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