Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I'm trying to set my theme file so that the Label Display Units come up as millions. (Otherwise the labels 'error' as there is too much text to fit in, therefore doesn't show them at all.)
Below is the code relating to the chart I want to do it with. Where below for "labelDisplayUnits" I have 0, I have tried Millions/millions but it doesn't work. Anything I put in the quotation marks other than 0 changes it to Trillions!
Is there a way I can make it show as millions? Alternatively, my issue would also be fixed if I could turn the 'Overflow text' option to ON. Is there a way to do this?
Thank you
"ribbonChart":
{"*":{"general":[{"responsive":true}],
"categoryAxis":[{"show":true}],
"valueAxis":[{"show":false}],
"labels":[{"show":true,
"color":{"solid":{"color":"#777777"}},
"fontFamily":"Segoe UI",
"fontSize":9,
"labelDisplayUnits":"0"}]}},
Solved! Go to Solution.
@abloor ,
See code below.
"labelDisplayUnits":{
"expr":{
"Literal":{
"Value":"1000000D"
}
}
}
Thanks for your reply. Can you please guide me as to which bit of that post is the solution to my question? Or did you put the wrong link up? I can't see how that relates to my question?
Thanks very much ![]()
@abloor ,
See code below.
"labelDisplayUnits":{
"expr":{
"Literal":{
"Value":"1000000D"
}
}
}
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!