Add $ prefix to numbers in Bar charts

(0) Share

Report

Posted on by Mando1

This is not okay:

The format I need is:

$10,000 and $7,830 (notice the $ sign and commas).

This is something I could achieve in a Pie Chart, passing the value to a gallery and adding:

Text(ThisItem.'ColumnName',"[$-en-US]$###,###")

and then taking the Chart values from that gallery. When I wanted to replicate the same on a bar chart, it just didn't work.

Categories:

Governance & administering

I have the same question (0)

All responses (4)

Answers (1)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report
Try something like the following:

"$" & Text(ThisItem.'ColumnName,"#,##0.00")

343434 should return $343,434.00.
You can remove the decimal places.

"$ " & Text(YourValue, "[$-en-US]###,###,###")

Was this reply helpful? Yes No
Mando1 2 on at

Like (0)

Report

Doesn't work. As I said, I already tried this.
I created a gallery giving this format to the labels... and the bar chart is still showing the numbers without the commas and the $ sign to the left.
This only worked on a pie chart, but I need it in a Bar chart.

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

Unfortunately, it seems that the series property cannot be formatted - as it is auto formatted within PowerApps:
See: https://powerusers.microsoft.com/t5/Building-Power-Apps/US-Currency-not-appearing-properly-in-the-Powerapps-chart/td-p/329214

Was this reply helpful? Yes No
Verified answer

chass on at

Like (0)

Report

Hello Mando,

Thank you for your post.

In terms of changing the charting control functionality in Power Apps, please consider posting a suggestion in https://ideas.powerapps.com so the engineering team can add it our backlog.

As a work around consider using the Power BI control. You can find documentation on this control here:

Power BI tile control in Power Apps - Power Apps | Microsoft Docs

Thank you for using the Power Apps Community,

Charles Sterling

Was this reply helpful? Yes No