Forum Discussion
Profile Graph
nawillia711 it is not clear from your post how does your raw data look like? Is the first table shows the raw data? What are 6 profile and what are the business rule to calculate x and y
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Some formatting didn't carry over from excel. I have updated the post to account for that. It is 7 x/y points that are calculated. For point 1 the x value is -Discharge Lifter A. Every other x point is 35 added to that. For the Y positions the first one is the Nail Length-Discharge Lifter B. For points 2-6 the y position is the Nail Length+Discharge Lifter P[1-6]-107 and for the final point it is Naile Length-Discharge Lifter E.
nawillia711 sorry I'm having a hard time following what we are trying to do here. I would recommend putting the data and calculations in the sample excel file and share excel file here, it will be easier to understand.