Forum Discussion

jtjones0304's avatar
jtjones0304
Frequent Visitor
6 years ago
Solved

Alternate Measure for Data Labels in a Column Chart

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!

Need Help
  • jtjones0304's avatar
    jtjones0304
    6 years ago

    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%.
     

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    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's avatar
      jtjones0304
      Frequent Visitor
      6 years ago

      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%.