How to graph data that goes up to 30,000 on a 100 y axis max Line chart ?

(0) Share

Report

Posted on by Usernametwice

503

Hi all

I have some data from a form field that can sometimes go up to 30,000. I also have a line chart that has a max y axis of 100 and need to display this field on the chart as 30 so it can fit nicely and be viewable. Does anyone know how to do this or would I have to look into power Bi implementation on the powerapp?

Please let me know if you need anymore info,

Thanks for the help and kind regards.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-chenzhi Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Usernametwice23 ,

Do you want to display the field as 30 in Line Chat turned out to be 30000?
Could you please tell me what’s your data source? Is the form a table or a control?
I assume the Form is a table and you want to fold all field by 1000% and made a test on my side.
Set the OnSelect property of Button to following:
UpdateIf(TableName,true,{column1:column1/1000})
Set the Item property of LineChat to following:
TableName
It could be like this.

Best Regards,
Zhi Chen

Was this reply helpful? Yes No
Verified answer

Usernametwice 503 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-chenzhi
I ended up creating another chart on top of my original chart. Thank you for your help!

Was this reply helpful? Yes No