Line chart table

Question

Hello, just wanna ask why my line chart shows different form my line chart in excel?
Here's my chart in excel

and here's my chart in Powerbi

and i just noticed that on the y axis my excel shows -1, -0.5 etc while on Power Bi only shows 0, 1, 2. How to format the line chart in power bi like excel? Thanks in advance.

spartabi · Answer

Anonymousunfortunately&nbsp;you can't control this. It's set by default by the values you have. I actually do get the 0.5 on my charts. Adding a sample file:Line chart table 2022-07-10.pbixDid you touch the Y axis limits and altered&nbsp;it from auto? That would cause the 0.5 marks to disappear.&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;Showcase Report – Contoso By SpartaBI

anonymous · Answer

Hello, no i didnt alter the y axis limits. I think i know the problem. The thing is my line chart doesnt go to zero it only lands on 1, how to set the line would land on zero and 1?

Here's my matrix, 0 values treats it as blank

spartabi · Answer

Anonymous&nbsp;so you need to change them to 0 before you load the table to the model. You can do that in Power Query through replace values null with 0&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;Showcase Report – Contoso By SpartaBI

anonymous · Answer

SpartaBI, actually that column have text in it i only count them depends on entries. Any possible solution?

spartabi · Answer

Anonymous&nbsp;can you share the file maybe?

Forum Discussion

Line chart table

6 Replies

Related content

Line chart

Power BI Interaction Issue Between Table and Line Chart

Time Line Chart

Previous Year Measure for Line Chart

Line Chart Issue