cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TKEnes
Helper I
Helper I

Edit single item of diagram

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @TKEnes ,

 

*** means different conditions.

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

 

Best Regards,

Wearsky

View solution in original post

3 REPLIES 3
v-xiaochen-msft
Community Support
Community Support

Hi @TKEnes ,

 

You could use If condition in your addcolumns formula.

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

 

Best Regards,

Wearsky

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

v-xiaochen-msft
Community Support
Community Support

Hi @TKEnes ,

 

*** means different conditions.

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

 

Best Regards,

Wearsky

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,282)