Formatting

[Anonymous]

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 · Accepted solution]

@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]

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]

@Anonymous , do the formatting of the column in model view as shown in the link. That should work