cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mando1
Advocate I
Advocate I

Add $ prefix to numbers in Bar charts

This is not okay:

2021-07-08_19h40_05.png

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
chass
Administrator
Administrator

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

View solution in original post

4 REPLIES 4
ekarim2020
Community Champion
Community Champion

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]###,###,###")

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.

ekarim2020
Community Champion
Community Champion

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-Po...

 

chass
Administrator
Administrator

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,394)