Column Chart Analytics Lines Error

[Dgreen23]

I'm building a report that shows Monthly Sales using a column chart. I need to have a dynamic Pace and Goal line. To do this I am using Odata to populate the fields for Pace and Goal. I then tied a max line to our Goal value and a min line to the Pace value. However, the values that those lines are registering as is 0. Has anyone else run into this issue or know of a decent workaround for getting both Pace and Goal dynamically integrated within the column chart? I have attached pictures for your consumption. All help is appreciated

[v-yingjl]

Hi @Dgreen23 ,

I’m not certain whether the Pace and Goal have correct values or what they represented. What I have tested the scenario in my environment, the max line and the min line works fine in the column chart.

Could you please share a sample .pbix file or more details for further discussion?

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Yingjie Li

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

[Dgreen23 · Accepted solution]

@v-yingjl,

I was able to figure it out. Apparently I accidentally removed the axis on the chart in question but left the values. This confused the Analytics section of power bi. Now that I have added the axis data back in it works just fine. Thank you for the inquiry!