Forum Discussion
Thousand separator
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
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])
9 Replies
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:
Hi mpavillard ,
You are using the previous version of the ribbon on the modeling tab when you select a column the option appears.
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
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
