I need some guidance on how to accomplish a break-even visual with an intercept like shown below.
Currently I have all the values in independent measures showing in cards. I have tried both a line chart and scatter plot for the visual but with only the single dot per measure I am unable to get the required result with lines.
I have watched all the training videos in Budgeting & Forecasting. I have also reviewed the thread @ Breakeven Analysis. However neither show what I am trying to accomplish.
Hi @rhyschappel. It’s difficult to say without seeing your work-in-progress … can you share your PBIX? (There’s also @BrianJ’s video (https://www.youtube.com/watch?v=VmWD7Ayw_NI) to reference if you need to sanitize your data.) Another avenue to explore is to create a table that has columns of data you want, then change it into the desired visual type and adjust from there. Hopefully this exploration will expose the category for the x-axis of your desired line chart.
Greg
@greg hit the nail on the head. If we know what the x coordinate is for each point, you can calculate the slope for each line using the breakeven point and the total cost point for the first line, and then the breakeven point and total revenue point for the second line, and then solve y=mx+b for b ( the y-intercept) for each line. At that point, you’ll have everything you need to plot both lines.
Hi @rhyschappel, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!
