Line Chart line is starting from 0

[Anonymous]

Hi All,

       The below image are line chart. The line is starting from above 30,000. Because, the values are present in data from above 30,000.

        But i need to start that line from 0 after that continous to what values present in data.

        Please help me.

        Thanks in advance.

[Anonymous · Accepted solution]

Hi @Anonymous ,

This is due to the design of the line chart, if you want the values to start at 0 then you can do the following:

1.We can create a table.

2.Click "transform data" to enter the power query, append the original table and the newly created table.

3.Create a rectangle that is the same color as the background of the matrix and cover the date [2019-2-1].

Best Regards,

Neeko Tang

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

[qqqqqwwwweeerrr]

Hi @Anonymous 

This should solve your problem:

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards

[Anonymous]

Hi @qqqqqwwwweeerrr ,

         Thanks for your reply.

          I need to the blue line only start from 0.

          Not the y-axis value.