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.
Hello everyone,
Power BI gives me all numbers as:
I would expect 2,265.60.
I have the english version and my location is set to US.
Thanks for helping.
Regards,
Chris
How are you getting that number in the middle of the Donut chart? Is that a separate visual, custom visual or what format settings did you flip on to do that?
@Greg_Deckler to get a customized donut chart with a "card inside" you can also download the following one: Donut Chart
Atanas
Oh, that is just a card in the middle of a donut chart 😄
No special Power BI effects 🙂
Do you know something regarding the decimal point issue?
That's what I figured. Hmm. I cannot replicate this. I created a number, 2265.60 using an Enter Data query, put it in a card visualization and set the Data label Display units to "None" and it showed up as 2,265.60. Definitely looks like a language setting kind of thing but not sure what would be causing that other than actually having a different language setting than US.
I don't know how to fix that ..
has to be a language or region setting somewhere I believe. is the euro mode.... not sure where - from the visual down to the actual table data....the install of Power BI, or even the Operating System (this would of course affect all your apps....)
I would be interested to know
..............and must confess - for some reason one install of Office among 5 PCs of mine gives tool tips in French and I've never fixed that so.......
Not sure whats behind it, as a quick fix, try wrapping a format around the measure =FORMAT(Measure,"#,###.00")
Since this applies to entire pages a formating function is not enough.
Maybe is really my system. The iOS application acts the same way.
Hmm .. Power BI Team .. please ..
Check the format setting in the control panel in your local PC. It would affect how numbers present locally.
In my case, setting format as "Italian(Italy)" uses a comma as the decimal point. Switch the format to English(United States) and reopen the pbix should work. Anyway, it is not a problem after publishing.
I believe when one options the visual's value to do math....that there is no ability to control the precision display. It is a feature that should be added as typically selecting the option to Average can result in long decimal displays that users just are always going to ask about ......
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |