Forum Discussion

Dgreen23's avatar
Dgreen23
Helper III
6 years ago
Solved

Column Chart Analytics Lines Error

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 m...
Need Help
Tips and Tricks
  • Dgreen23's avatar
    Dgreen23
    6 years ago

    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!

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

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's avatar
Dgreen23
Helper III
6 years ago

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!