cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pracmt1515
Level: Powered On

can i modify the markers value from a column chart?

I need to modify the markers value from a chart by (*100) and adding "%" at the end, can be possibly ?. and sorry for my bad english btw 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: can i modify the markers value from a column chart?

@pracmt1515 

Your best way to format or alter the values, labels or any other thing about charts is to shape your data for the chart specifically. 

In this case, you might consider something like this for the Items property of the chart:

   AddColumns(<whateverYourCurrentItemsPropertyIs>, "newMarkerValue", oldMarkerColumnName * 100)

Then, just choose the "newMarkerValue" for your values.

 

I hope that helps some.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
2 REPLIES 2
Super User
Super User

Re: can i modify the markers value from a column chart?

@pracmt1515 

Your best way to format or alter the values, labels or any other thing about charts is to shape your data for the chart specifically. 

In this case, you might consider something like this for the Items property of the chart:

   AddColumns(<whateverYourCurrentItemsPropertyIs>, "newMarkerValue", oldMarkerColumnName * 100)

Then, just choose the "newMarkerValue" for your values.

 

I hope that helps some.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Community Support Team
Community Support Team

Re: can i modify the markers value from a column chart?

Hi @pracmt1515 ,

 

Like @RandyHayes  suggested, you could use AddColumns to use a new column to make it work. First you could create a collection using your data source and then add the column to this collection. Then use this collection as the data source of your Chart control.

 

Set OnStart property of your app to below formula to create the collection:

ClearCollect(C1,TableName)

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

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

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 42 members 4,085 guests
Please welcome our newest community members: