Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Formatting

Hi All,

I have a "Text" column in my report and have formatted it as a Count (Deal Count #).

Is there a way i can add "," to the column like the number should look like 1,240 and the total like 178,994?

Regards,

Himanshu

amitchandak
5 years ago
Anonymous , refer if this can help you to format

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

or a measure like format([Deal Count#],"#,###.#")

3 Replies

amitchandak
Super User
5 years ago
Anonymous , refer if this can help you to format

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

or a measure like format([Deal Count#],"#,###.#")
- Anonymous
  Not applicable
  5 years ago
  Hi Amit,
  
  Yes a measure will work fine I know but just wanted to know if there is another solution without creating a measure as creating a measure everytime is not a solution is i have multiple columns in my report.
  
  Regards
  - amitchandak
    Super User
    5 years ago
    Anonymous , do the formatting of the column in model view as shown in the link. That should work