Can't edit Average line

[Inverno]

Hello.
I have a simple clustered column chart with the average line:

Why can't I edit the average line, as the edit options are greyed out?

Weird thing is that before I've added the "2024" data (orange column) I've had the average line perfectly edited. After adding the 2024 data, I can't do anything with the line. So weird...

Thanks in advance.

[v-yajiewan-msft · Accepted solution]

Hi @Inverno, amitchandak, thank you for your prompt reply!

Per my test, I transformed the data to add the values for 2024 to the same table and I can still edit the average line as shown below:

Please remove the existing average line and add again to compare the result.

Make sure the version of Power BI is up to date, sometimes version issues can cause such UI exceptions.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Inverno]

Thanks for the reply.

It may have been an update issue as I did update it to the last version and it works now.

Thank you

[amitchandak]

@Inverno , Use Constant Line, there using Fx you can use measure

You can check examples here https://youtu.be/0k_C_E7YOQY?t=277