Show numbers in different format

Patrick_Cruz · 2023-04-27T09:22:49+00:00

There was an error rendering this rich post.

Hi! I have a stacked bar chart whose formatting for values must follow a specific set of rules. If it is above 1 million (example 9,483,321), it will be displayed with 1 decimal place, scale-abbreviated (to 9.5M in the example). If it is below 1 million, it should be displayed with no decimal place, scale abbreviated (like 570,754 to 571K). This should be for the totals and values per category. Is this possible to do currently in DOMO?

Find more posts tagged with

Accepted answers

MarkSnodgrass

In your y-axis, choose Format and Display as Number and set the number of decimals to 1. Then in the Chart Properties - Data Label Settings, select Use Scale Abbreviation. This might get you what you want.

All comments

MarkSnodgrass

ST_Superman

@Patrick_Cruz - I'm not sure of a way to accomplish this. I believe this would need to be a feature request. There may be a way to accomplish this kind of labeling using a DDX brick, but I don't have the coding skills to help you there.