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
Memorable Member
Memorable Member

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
Memorable Member
Memorable Member

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
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,838)