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!!
HI chiccofff
Can you provide more context like screenshots here with the issue?
It is hard to understand what you are asking here. What visual are you referring to here with Data Labels issue?
When I use a line chart in Power BI, I do have option for data labels with thousand separator and also to set decimal places as in the screenshot below:
kindly add more details to your query above.
Please create some mock data in Excel: 1000 different names (text field) belonging to Department 1, and 1000 different names belonging to Department 2. If you create a bar chart with the count of names per department, and after you add a data label and a total label, it will show "1000","1000" and "2000" as labels. However, if you format the "Value" of the data label to zero decimal places the total label is updated showing the thousand separator ("2.000" - point or comma depending on your country specifications) whereas the specific data labels remain unchanged (1000). So I am guessing this is some kind of bug, as the software reacts differently
