Alternate Measure for Data Labels in a Column Chart

[jtjones0304]

I am trying to create a column chart which uses a percentage measure for the column values in a column chart but display the absolute values as data labels.  I've also added a constant line at 100% for perspective which is available in a column chart.

I tried using a combo with the absolute measure values as line values, setting the stroke width to zero and enabling data labels.  However, combo charts do not allow constant lines so I can't show the 100% line.

Does anyone know of another possible workaround or a custom visual which will do this?

Thank you!

[parry2k]

@jtjones0304 not sure what you are looking for but you can add a constant line on the combo chart by using 2nd measure on the line value section of the combo chart, create a measure with a fixed value for constant line and put that on line value section, along with other measures. if I'm totally off track, share some screenshots that you are trying to achieve.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[jtjones0304 · Accepted solution]

Thank you for the quick response.

I figured out a workaround.  What I'm ultimately looking for is to display different data labels than the measure used in values and want the labels to display at the bottom of the chart.  

1. I created a combo chart with the alternate data label measure as the line
2. Set line stroke width to zero
3. Set the secondary Y axis label text to white to match the background to make it dissappear
4. Set the secondary Y axis minimum value to a very large number to force the line, and the labels, to the bottom of the scale
5. Instead of using 100% line, used a stack bar with the remaining % to 100%.