Taher Assaid on 18 Mar 2020 18:53:48
Ability to change the display unit of the data label to a custom value instead of the default options (None, Thousands, Millions, Billions, Trillions)
- Comments (10)
RE: Custom Displaly Unit for Card and Gauge Visual
How many votes do we need for this? Its a very important feature to make refined dashboards.The alternative is to manually format all of my measures to text which is a massive pain.
RE: Custom Displaly Unit for Card and Gauge Visual
It seems that unit of charts suddenly became linked to the language setting of PBI service. It's really frustrated not being able to customize the unit display.
RE: Custom Displaly Unit for Card and Gauge Visual
I want to be able to show GigaBytes (GB) instead of Billion (bn)
RE: Custom Displaly Unit for Card and Gauge Visual
This seems like a relatively simple fix, and many people would benefit from it. My customers are also confused and get a bad taste in their mouth about Power BI when they see this kind of limitation.
RE: Custom Displaly Unit for Card and Gauge Visual
This is a frustrating limitation.
RE: Custom Displaly Unit for Card and Gauge Visual
Scales like kilo, Mega, and Giga (k, M, G resp.) are common too, and so being able to set the appropriate abbreviation in charts and cards is really useful to have those values scale logically.
RE: Custom Displaly Unit for Card and Gauge Visual
My client uses this format:
1,000 = 1M
1,000,000 = 1MM
It would clarify things to be able to customize this.
RE: Custom Displaly Unit for Card and Gauge Visual
Related to a similar request:
"Auto display units should detect and display percentage"
https://ideas.powerbi.com/ideas/idea/?ideaid=704ae943-d5d5-40c7-8259-0a46841a251f
RE: Custom Displaly Unit for Card and Gauge Visual
Where I live, The Netherlands, we're used that 1.000.000.000 is 'miljard' and 1.000.000.000.000 is a 'biljoen'. So the abbreviation bn is just plain confusing for us. K, mln., mld. and bln. are used over here as abbreviations.
RE: Custom Displaly Unit for Card and Gauge Visual
To clarify - Currently, I have a report which displays values both in the millions and in the billions, and the Display Units are set to auto on both cards and a bar chart. However, the unit abbreviations displayed are :
bn = billions
M = millions
The client would prefer to see a 'B' used to represent billions
We would like a way to customize these display units.