I have a line chart which is showing information for all employees of a company. My dimension is EmployeeName, and my expression is BonusPercent. I want to see all the data points, but I only want to show the name on the axis for certain employees - the ones who get a Bonus of more than 10%. Is there a way to keep all the data points showing, but only see labels for the specific employees?
I tried setting it to Show Values on Data Points, and adding in another expression set to zero right above it. I then did a split axis so the data points would be on the bottom. I'm still left with a space between the split (even when I set it to 99% for the primary), and my axis labels on the right instead of the left. Any idea if there's a better way to do that?
Unfortunately, no, I can't share the qvw. If I have a chance I'll set up a similar one with a dummy table.
I did progress things a bit further. Using Values on Data Point allows you to make the text vertical, so I tried that. The issue then is it puts them on the point of the expression above it, or zero, whichever is greater.
I created a new expression with a value of 0, with a white line. I then did a split axis and put the 0 and names on the bottom/left, with the others on the top/right. This put the names on the bottom, with the rest of the chart above it. The issue is there's a big split between the names and the rest of the chart, and the values are now shown on the right, when I want them on the left.
