Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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.

  • Anonymous's avatar
    Anonymous
    Not 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