Forum Discussion
Error with thousands separator
Good, A while ago I've been dragging this problem, but I can't find a solution in any language.
When I add thousands separators to a numeric value it only gives me the first separator from right to left, an example would be something like this:
5,000,000 (As it should be)
5000,000 (As seen)
It only happens with values with 6 or more "zeros" for obvious reasons.
I've already tried to change the regional format and so on, but I can't fix it, it's quite annoying.
Thank you very much in advance!
Hi OriExil ,
You can try to use custom format strings in Power BI Desktop. More Info: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
I create a column typed as whole number. Like below:
Click the Model View, choose the column and then we select Custom in Format. Steps are shown as below:
We will have three options to choose:
Choose the third one and then delete $:
Result:
If this can't work, you could create a calculated column with FORMAT function:
Column = FORMAT('Table'[Column1],"#,###,###")Note: FORMAT function returns text values.
5 Replies
Hi OriExil ,
You can try to use custom format strings in Power BI Desktop. More Info: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
I create a column typed as whole number. Like below:
Click the Model View, choose the column and then we select Custom in Format. Steps are shown as below:
We will have three options to choose:
Choose the third one and then delete $:
Result:
If this can't work, you could create a calculated column with FORMAT function:
Column = FORMAT('Table'[Column1],"#,###,###")Note: FORMAT function returns text values.
Funciono perfectamente, muchisimas gracias!
