Forum Discussion

nidhisakariya's avatar
nidhisakariya
Frequent Visitor
3 years ago
Solved

Strange problem with line chart

Hello all, I am facing a problem in the line chart visual.. I have a companies profit and loss data, for its 3 branches for 12 months! I have added it up and created a line chart where Y-axis is t...
Need Help
  • mussaenda's avatar
    mussaenda
    3 years ago

    Hi nidhisakariya ,

     

    try rounding your value in with ROUND(your value, how many decimal places)

     

    Then try if this will still happen

mussaenda's avatar
mussaenda
Community Champion
3 years ago

Hi nidhisakariya ,

 

try rounding your value in with ROUND(your value, how many decimal places)

 

Then try if this will still happen

  • nidhisakariya's avatar
    nidhisakariya
    Frequent Visitor
    3 years ago

    Hi mussaenda 

    It worked for the chart, thank you so much!

    But it is not working for the average line.. I have added it the average line as well and we do not write a formula manually for that so is there a way to have it for Average line as well?

    • mussaenda's avatar
      mussaenda
      Community Champion
      3 years ago

      Hi nidhisakariya ,

       

      apply the same in average formula and i think it will also work

      • nidhisakariya's avatar
        nidhisakariya
        Frequent Visitor
        3 years ago

        mussaenda I am not writing a formula for it, I am adding it directly from the analysis tab in power bi