web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Format series text Col...
Power Apps
Unanswered

Format series text Column Chart

(0) ShareShare
ReportReport
Posted on by HealthyChris 2

Hi All,

I have a column graph that is getting data from a collection. 

The collection, called ColTotals, has 2 columns, one called "Qtr" the other called "Total"

Every quarter for the year has a corresponding total.

 

I'm displaying the data in a Column chart, by assigning colTotals to the items property of the chart. It looks good.

But the text values at the top of each column have many decimal points and are not in $.

I read this Link and changed my Items formula to this

AddColumns( colTotals,"USD",Text(colTotals.Total,"[$-en-US]$ #,###","en-US"))

 

I'm confused as I still get an error that indicates "colTotals.Total" should be a text or a number, but in it definitely has a number in it.

 

Any suggestions on whats wrong?

 

 

 

 

 

 

Categories:
Building Power Apps
  • xzDan Profile Picture
    xzDan 350 on at

    What if you change colTotals.Total with Value(colTotals.Total) ?

  • CarlosFigueira Profile Picture
    CarlosFigueira Microsoft Employee on at

    Within an AddColumns call for the table colTotals, all members of that table are in scope - so if you want to access the 'Total' property, you can do it directly. When you specified "colTotals.Total" as an argument of the Text Function, then you went you went out of the record scope and back to the "global scope", retrieving a table with all values for the 'Total' property of colTotals. If you change your expression to this:

    AddColumns(
 colTotals,
 "USD",
 Text(Total, "[$-en-US]$ #,###", "en-US"))

    I believe you should get the result you want.

    Hope this helps!

  • HealthyChris Profile Picture
    HealthyChris 2 on at

    Hi Carlos,

    thanks for getting back to me and explaining the scope, what your saying made complete sense.

    I changed the formula and the error went away. Smiley Happy

    I switched the Series labels on the Advanced tab to use the new "USD" column, but sadly the format series labels didn't alter 😞

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 432 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 347

#3
WarrenBelz Profile Picture

WarrenBelz 254 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans