Forum Discussion
Line Graph Intercept X=0 at Y=1
Is there anyway to make a line graph intercept X=0 and Y=10 without editing the dataset. This is thousands of data points that were not given starting value. I appreciate any help.
|
2 Replies
- AnonymousNot applicable
Hi Anonymous ,
What do you mean “Intercept ”? Could you please share the expected output?
In case you only want to show the value when X=0 and Y=10, please try to add a measure and then apply it to filter pane:
Measure = IF(MAX('Table'[X])=0 && MAX('Table'[Y])=10,1,0)Refer to:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - AnonymousNot applicable
Essentially this is data pulled from our database looking at the failure of items over time. When they started the database they did not enter a time 0. At 0 the item is intact or a 10 on the Y-axis. In the past they have been manually added x=0 y=10 to each graph. I am trying to figure out a way to either automatically start all figures at x=0 y=10 or add x=0 y=10 to the large dataset. See below the orange line is what I want to add