Forum Discussion
Data label - Thousands Separator - bug?
Data labels inherit the base field format, not the visual's value formatting.
Create a calculated column that formats the number:
Formatted Count =
FORMAT([Your Count Column], "#,##0")Use this column for your data labels.
If this answer helped, please click Kudos or mark as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pandeIt’s not a bug, Power BI is simply designed that way.
If you use implicit measure, Power BI shows thousand separators only on the total, not on the data labels. The usual formatting trick is setting Decimal places = 0, doesn’t apply to data labels.
Solution: Format the column directly in the data model and enable thousand separator.
Once you do that, the separator shows everywhere automatically, totals and data labels.Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
chiccofff when you click on numeric column, there is option to set thousand separator:
In addition, in formatting, values, you can change decimals if needed (on chart i set 3 decimals, in column formatting i set 1 decimal).
If this doesn't work, could you send screenshot of your example?
Alternative: create simple chart like this with labels formatted properly and then convert chart to the one that you need.
If thousand separator is lost, labels on that specific chart can't use column formatting and the best way to solve it is using a measure where you have full control.
Cheers,
Nemanja