Forum Discussion
Specifying thousand separator when using SSAS
Arklur ,
I'm afraid whole number, decimal number and fixed decimal number don't have the format which can meet your requirement. So, as a workaround, you may change the type of column value to text type using DAX function FORMAT(<value>, <format_string>).
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Arklur ,
This issue is caused by power bi can't recoginize the comma you added in the number. You can change the number in data source or in SSAS using SSDT and check if this issue persists.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
I think there is a misunderstanding here, there is no comma in the number. The number is just a measure (Data Type = Decimal Number), which returns (in this case) "10000". This should be represented as "10.000" and not "10 000".
Arklur ,
I'm afraid whole number, decimal number and fixed decimal number don't have the format which can meet your requirement. So, as a workaround, you may change the type of column value to text type using DAX function FORMAT(<value>, <format_string>).
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
