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 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,

    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!

2 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support

    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

      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!