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)

Sort by

Ellis Karim 12,079 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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 12,079 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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