Bar chart : adding an average line change value of a previously added constant line

[Gato]

Hello everyone,

Working on a clustered bar chart, I have added a constant line to display the average sale amount, everything behaves as expected.

Then, I decided to add an average line using the dedicated button :

As soon as the new line (in pink on next picture) appears, the first line drops to zero (in blue) 

Can someone explain why adding a separate newt line affects the previous one? It this a bug?

You can find  here a file based on AdventureWorks dataset to recreate the issue yourself

[Anonymous]

Hi @Gato 

I ran a test and found that it seems to depend on how you aggregate the values. When you select average,  constant line moves to the 0 side.

Best Regards,
Community Support Team _ Ailsa Tao