Can we write a formula inside the ColumnChart Series, is it possible

(0) Share

Report

Posted on by johnjohnPter

1,803 Super User 2024 Season 1

I have this SharePoint list which contain 2 columns:-

1) Target Amount

2) Actual Amount

now i can showing them inside a Column chart inside a vertical gallery as follow:-

Now i do not want to show numbers, instead i want to show percentages, mainly to divide the (Actual Amount / Target amount) and show this percentage inside a column + second column showing 100. is this possible? mainly if i can define formula inside the Series? or i need to create 2 additional columns inside the list? one which is calculated (Actual Amount / Target amount) and one with a static value of 100?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Garima_PowerPlatform 170 on at

Like (0)

Report

Can we write a formula inside the ColumnChart Series, is it possible

Hi

Yes, you can display percentages inside a column chart in PowerApps without needing to add extra columns in your SharePoint list. You can define the formula directly in PowerApps to calculate the percentage (Actual Amount / Target Amount) and use that within the chart's series.

[
{
"Name": "Actual",
"Value": ThisItem.'Actual Amount' / ThisItem.'Target Amount' * 100
},
{
"Name": "Target",
"Value": 100
}
]

Set item property of the chart

yourgalleryname .AllItems

Was this reply helpful? Yes No
johnjohnPter 1,803 Super User 2024 Season 1 on at

Like (0)

Report

Can we write a formula inside the ColumnChart Series, is it possible

CU04120610-0

Thanks for the reply, but where i need to add this formula?

[

{

"Name": "Actual",

"Value": ThisItem.'Actual Amount' / ThisItem.'Target Amount' * 100

},

{

"Name": "Target",

"Value": 100

}

]

you mean to build a collection containing those new fields? if so, then i am not sure if this will work as the collection can hold up to 2 k items..

or this will be within each gallery item?

Was this reply helpful? Yes No