Forum Discussion
Data label - Thousands Separator - bug?
- 8 months ago
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-pande - 8 months ago
It’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!!
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-pande