 <p>I think I have an answer for you. In this you do not have to flip the y-axis, and I can get the names in the x-axis, but I still use a hierarchy. I'm not sure it's more efficient, but here goes.</p> <p>First, I created a Hierarchy defined as:</p> <pre><code>CREATE NESTED HIERARCHY [New hierarchy (2)] [yearsOfExp] AS [yearsOfExp], [name] AS [name] </code></pre> <p>This allowed me to order the category axis by years of experience.</p> <p>Secondly, I created a calculated column defined as: </p> <pre><code>Sum([yearsOfExp]]) over (AllNext([yearsOfExp]])) </code></pre> <p>I then created a line chart. The hierarchy is the x axis and the calculated column is the y axis. When setting the x axis, be sure to "reverse scale". <a href="https://i.stack.imgur.com/9RL8C.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9RL8C.png" alt="enter image description here"></a></p> <p>I hope this does what you're looking for. Good luck. Any questions, just ask.</p>