Forum Discussion
Line chart table
Anonymousunfortunately 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.pbix
Did you touch the Y axis limits and altered it from auto? That would cause the 0.5 marks to disappear.
- Anonymous4 years agoNot applicable
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
- SpartaBI4 years agoCommunity Champion
Anonymous 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
- Anonymous4 years agoNot applicable
SpartaBI, actually that column have text in it i only count them depends on entries. Any possible solution?