Forum Discussion
Alternate Measure for Data Labels in a Column Chart
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.
- I created a combo chart with the alternate data label measure as the line
- Set line stroke width to zero
- Set the secondary Y axis label text to white to match the background to make it dissappear
- 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
- Instead of using 100% line, used a stack bar with the remaining % to 100%.
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!
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.
- I created a combo chart with the alternate data label measure as the line
- Set line stroke width to zero
- Set the secondary Y axis label text to white to match the background to make it dissappear
- 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
- Instead of using 100% line, used a stack bar with the remaining % to 100%.