Thousand separator

[mpavillard]

Hi everyone,

I'm really new to Power BI and I'm having issues with probably the easiest thing ever. I just built a bar chart that gives me the following values: 57003, 5637 and 2995. How can I make it so it gives me 57.003, 5.637 and 2.995? It would seem the easiest thing, but I can't find it anywhere.

Thank you

[lbeneyze]

Hi Mpavillard,

I would change the datatype of the column in Power Query to Whole Number:

Button "Data type" in "Any Column" group under "Transform" ribbon tab

Then you can do what you want on Power BI Desktop.

Good luck

Did I answer your question? Please mark this post as a solution.

Kudo's are always accepted. Hit the thumbs up button 👍

Kind regards,

Lohic Beneyzet

[MFelix]

@lbeneyze  how can you change a city name to a number format? That will return an error since the fields are not matching.

[lbeneyze]

@MFelix 

In the original message: "I just built a bar chart that gives me the following values: 57003, 5637 and 2995. How can I make it so it gives me 57.003, 5.637 and 2.995?"

Based on this information and the fact that the data is text, i assumed that the initial column could be converted to a whole number.

That's why I suggested this answer.

Kind regards,

Lohic Beneyzet 

[MFelix]

Hi @mpavillard ,

That has to do with the formatting, select the column or measure then go to the columns/measure options and activate the comma:

[mpavillard]

Thank you @MFelix but mine doesn't show the Column tab:

[MFelix]

Hi @mpavillard ,

You are using the previous version of the ribbon on the modeling tab when you select a column the option appears.

[mpavillard]

But it's greyed out, I can't select it. I think it's due to the fact that the data type is Text, but I can't change it, because it's actually a count of records of a text field, so that's correct.

If I try to change it to Whole number, I get the following error:

Imagine this was a list of cities, and I wanted to know the number of cities in a certain country. That of course would be a count and would return a number, but the data is actually text. Why can't I format that count?

[MFelix · Accepted solution]

Not @mpavillard,

He did not refer to it being a text value. In that case, create a measure like the following and create the format of the field.

MEasure = COUNT(TAble[Columna])

[mpavillard]

Thank you @MFelix , that finally did it!! sorry about all the messages back and forth, but I'm very new at Power BI.