Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Gato

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

Submitted by on ‎12-28-2022 10:34 AM

Hello everyone,

 

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

Gato_3-1672251786722.png

 

 

Gato_0-1672251401955.png

 

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

Gato_1-1672251505140.png

 

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

Gato_2-1672251573162.png

 

 

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

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎12-30-2022 01:04 AM

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.

Ailsamsft_0-1672390911679.png

Ailsamsft_1-1672390941600.png

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses