# Power chart pen control values out of control

**URL:** <https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [August 11, 2021, 1:14pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809 "2021-08-11T13:14:23Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![louagejasper](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/louagejasper/32/86311_2.png) [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\
**Post date:** [August 11, 2021, 1:14pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/1 "2021-08-11T13:14:24Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/7/e7a96810c918de1edc76c2fc126254718c7f67df.png)

Hi all,  
In the Power Chart, the pen control values are out of hand when the locale is set to non-American number notation. As you can see, my min and max is x1000 and my average is completely out of control.  
Is this a bug that is known and worked on?

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [August 11, 2021, 1:36pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/2 "2021-08-11T13:36:32Z")

</div>

you will have to format the values so that it will consider the decimal notation right (comma and dots )

---

<div class="post-metadata">

**Author:** ![louagejasper](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/louagejasper/32/86311_2.png) [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\
**Post date:** [August 11, 2021, 2:11pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/3 "2021-08-11T14:11:48Z")

</div>

Thanks for the reply. Does this mean you cannot bind your data like this?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/d/8d2db5c8ea35e6d0993f8cb3e9ee9f1846687ac9.png)

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [August 11, 2021, 2:20pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/4 "2021-08-11T14:20:41Z")

</div>

I think you can change the dataFormat in the axes.  
actually no idea how it works with locals tho.  
are you sure that in the dataset it is saved as numbers and not string?

---

<div class="post-metadata">

**Author:** ![louagejasper](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/louagejasper/32/86311_2.png) [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\
**Post date:** [August 12, 2021, 7:39am UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/5 "2021-08-12T07:39:52Z")

</div>

The dataset does save the values as float values:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/a/ba35b58bbb2b80ec063e5519d1f96f066a01744d.png)

I can change the dataFormat property on the axes, but that will only change the way I format the really big number, not make them smaller. I would think the powerChart component formats the data wrong when doing calculations on the data, I wonder if it’s possible to influence this.

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [August 12, 2021, 9:25am UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/6 "2021-08-12T09:25:12Z")

</div>

idk ive not used the powerchart before.  
I suppose you do some formating in your query, turn it into a string there and then trim/replace the dots/commas

---

<div class="post-metadata">

**Author:** ![louagejasper](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/louagejasper/32/86311_2.png) [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\
**Post date:** [August 12, 2021, 9:55am UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/7 "2021-08-12T09:55:33Z")

</div>

Ok, it’s really a powerChart issue I’m having, because the power of powerChart is that I don’t do any of the querying myself, The only thing I need to configure is which tag from the TagHistory it needs to show. So I can’t influence any querying done here, I think…

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/d/8d2db5c8ea35e6d0993f8cb3e9ee9f1846687ac9.png)

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [August 12, 2021, 10:33am UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/8 "2021-08-12T10:33:00Z")

</div>

ah hm no idea then sorry

---

<div class="post-metadata">

**Author:** ![louagejasper](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/louagejasper/32/86311_2.png) [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\
**Post date:** [August 12, 2021, 12:18pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/9 "2021-08-12T12:18:17Z")

</div>

> [@louagejasper](#):
>
> hart issue I’m having, because the power of powerChart is tha

Thanks for trying to help!

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [August 12, 2021, 1:48pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/10 "2021-08-12T13:48:37Z")

</div>

you can always try and set the locale of the service to US, then atleast the values wont be multiplied

> [@\[Bug-2323\] number conversion Gateway locale(?)](https://forum.inductiveautomation.com/t/bug-2323-number-conversion-gateway-locale/45750/7):
>
> So changing the locale (or the date formatting in the current locale) will only change the behavior of being able to make saving the simulator program work in a reliable manner. In the following screen recording, you will see the following: Initially my Windows system is configured to start an Ignition service as my user tester that is setup for a French locale, with French data formatting. I display the simulator program in this context on the server itself and on my local system which has E…

---

<div class="post-metadata">

**Author:** ![louagejasper](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/louagejasper/32/86311_2.png) [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\
**Post date:** [August 12, 2021, 2:24pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/11 "2021-08-12T14:24:15Z")

</div>

Yes, that can be a solution. Hope this will get fixed soon tho.

---

<div class="post-metadata">

**Author:** ![henning.e.heine](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/henning.e.heine/32/70958_2.png) [@henning.e.heine](https://forum.inductiveautomation.com/u/henning.e.heine)\
**Post date:** [April 19, 2022, 7:06pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/12 "2022-04-19T19:06:02Z")

</div>

Hi @louagejasper! Did you get the issue with the power chart fixed. I am experiencing the same problem. Changing the axes dataFormat property does not seem to help.

---

<div class="post-metadata">

**Author:** ![louagejasper](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/louagejasper/32/86311_2.png) [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\
**Post date:** [April 19, 2022, 7:44pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/13 "2022-04-19T19:44:38Z")

</div>

Hi Henning,  
My solutions was to only use locales that use ‘.’ instead of ‘,’.  
I think I used Luxemburg locales or something as a workaround…  
But no real solution for the countries that use comma’s.  
In the application we do use comma formatting instead of the point formatting.

Jasper

---

<div class="post-metadata">

**Author:** ![bruno.nunes](https://avatars.discourse-cdn.com/v4/letter/b/a5b964/32.png) [@bruno.nunes](https://forum.inductiveautomation.com/u/bruno.nunes)\
**Post date:** [May 5, 2022, 3:05pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control-values-out-of-control/49809/14 "2022-05-05T15:05:41Z")

</div>

Hello.

I would consider this something that should be addressed. I’m having the same problem, to the point where I tend to ignore the advantage of having Pen Control visible, and changing locales is not in my plans.
