Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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])
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi 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
@lbeneyze how can you change a city name to a number format? That will return an error since the fields are not matching.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsIn 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
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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @mpavillard ,
You are using the previous version of the ribbon on the modeling tab when you select a column the option appears.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsBut 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?
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])
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you @MFelix , that finally did it!! sorry about all the messages back and forth, but I'm very new at Power BI.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |