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.
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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.
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)
Find your favorite faces from the community presenting at the Power Platform Community Conference!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021