Flat Average Line in Y-axis chart

[Rafaelb96]

Hi support, 

I am encountering a challenge with one of my Y-axis data showing as flat against different events. My second y-axis is appearing just fine and both settings look similar. 

I have ''linked'' all files with Auction No. (I made sure all data sheets have the same format ex: 01. SONGWE-M1, 02. MBINGA-M1, etc.) Somehow only the TCB results Average Price is fluctuating from one auction to the other. 

I am attaching files for references. 

Can anyone share thoughts and support please?? 

Thanks,
Rafael

[_AAndrade · Accepted solution]

As I can see, there is no active relationship between the Regional Auction and the TCB Results. Try activating this relationship and see if that solves your problem.

[Rafaelb96]

Hi _AAndrade, 

It worked! Thank you!

[_AAndrade]

Great. Please mark my answer as a solution to your problem.

Thanks