Answered

Edit single item of diagram

(0) Share

Report

Posted on by TKEnes

How can I edit a single item of a linechart? I have a linechart with different results (logically) and I want to have a different calculation for each item/result. For example there is a line that has a y-value of 200. How can I make the 200 * 2? At the same time I want a different calculation for another y-value. For example Y(300) * 4. How can I achieve that? I have made an extra column but with that the calculation is made on every y-value.

AddColumns(colAverage, "test solved", Solved/7

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TKEnes ,

You could use If condition in your addcolumns formula.

AddColumns(colAverage, "test solved", If(***, Solved/7,***,***))

Best Regards,

Wearsky

Was this reply helpful? Yes No
TKEnes 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for the late reply. What does the *** mean? The first one the list name probably but the other ones?

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TKEnes ,

*** means different conditions.

AddColumns(colAverage, "test solved", If(Condition1, Result1,Condition2,...))

Best Regards,

Wearsky

Was this reply helpful? Yes No