Data label - Thousands Separator - bug?

[chiccofff]

If you do a count or sum of a specific field of a database without using a measure (and formatting it), usually there is a trick to add the thousands separator : in "values" you set the decimal places to zero. Magically the "thousands separator" appears.

However, this is true for the "Total Labels" but not for the "Data Labels" .

Is it a software bug?

Can it be fixed?

Is there a workaround that does not involve creating a measure?

[Kedar_Pande · Accepted solution]

@chiccofff 

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

[v-prasare]

Hi @chiccofff,

As we haven't heard back we are following up regarding your question. Could you please confirm if the responses provided by the community members helped resolve your query? If not, please let us know we are happy to assist further.

Thanks,

Prashanth Are

MS fabric community support

[v-prasare]

Hi @chiccofff,

we are following up regarding your question. Could you please confirm if the responses provided by the community members helped resolve your query? If not, please let us know we are happy to assist further.

@Jaywant-Thorat, @Kedar_Pande, @nandic & @Pragati11 , Thanks for your prompt response

Thanks,

Prashanth Are

MS fabric community support

[Jaywant-Thorat · Accepted solution]

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!!

Linkedin: https://www.linkedin.com/in/jaywantthorat/

[Kedar_Pande · Accepted solution]

@chiccofff 

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

[nandic]

@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

[Pragati11]

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.

[chiccofff]

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