cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KK-Kalinga
Level: Powered On

US Currency not appearing properly in the Powerapps chart

I am using bar chart in the Powerapps and getting data from the Excel sheet. 

The currency column value in the Excel sheet is $52,000.60 but in the chart it is appearing as 52000,60.

How can I show the data in the chart properly with proper comma and decimal value. Please suggest.

3 REPLIES 3
Super User
Super User

Re: US Currency not appearing properly in the Powerapps chart

@KK-Kalinga 

 

Try creating a Collection on App Load as shown below :

 

Collect(colData,AddColumns( TableName,"Currency",Text( ColumnName,"[$-en-US]$###,###.00")))

TableName- Table name in excel

Currency - new column to store data in currency format

ColumnName - name of column where currency info is stored in excel

 

This should create a collection with your excel data and should include the currency formatted data in the new column added which you could use in the chart

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

Highlighted
KK-Kalinga
Level: Powered On

Re: US Currency not appearing properly in the Powerapps chart

Thank you @RezaDorrani  for cheking it out and providing the formula.

I checked but it does not seems to be working. I added the new data as "hola" with currency 50,000.01 but its not appearing properly.

I have attached the screenshots from powerapps, my excel and chart data. 

Super User
Super User

Re: US Currency not appearing properly in the Powerapps chart

@KK-Kalinga 

 

Looks like it only appears in correct format when the new column is used in Labels property of the chart control 

The series property does not showcase the value in the correct format

The series property cannot be formatted (it is auto formatted within PowerApps)

 

 

 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 78 members 3,731 guests
Please welcome our newest community members: