Forum Discussion
Continued ContributorMoving data labels to max value when you have multiple lines
Hello All,
I could use some help with trying to move the data labels to above the max value on the chart. I've tried multiple different ways watching How to PowerBI YouTube channel videos but I can't get anything to work. The two lines are one measure that has a legend to show previous year vs current year. Ideally, I would like a constant line that is slightly above the max value (whether or not it's previous year or current year) where I can show the % change. Any ideas on how I can accomplish this would be greatly appreciated. Thanks!
I ended up finding a solution that worked. I change the measure to display the data but I ended creating a PY and CY measure. Then added a third line that calculates the max and multiplies it by 1.4 to add some need space.
3 Replies
nleuck_101I ended up finding a solution that worked. I change the measure to display the data but I ended creating a PY and CY measure. Then added a third line that calculates the max and multiplies it by 1.4 to add some need space.
- d_m_LNK
Super User
To create more space on the graph you could specify the min max values on the Y-Axis portion of your graph. This way you can control how much space above your max value you will have.
In the format menu there is also a reference line you can take advantage of on the line chart visual to help you get the constant you are looking for:
- nleuck_101
A reference line would only show me a constant line with one value. I need to show the value above each month.
