Forum Discussion
Y Axis values resizing graph
Hi,
I have a formatted graph that when i select a different field the Y Axis seems to resize causing the graph position to change.
To fit with a client design we had to add some line shapes to the end of the bars this was a design piece to fit in to branding of the company. The issue i have is each time i select a field with different values the Y-AXIS lables seem to shift causing the Line shape to be in the wrong position, images below. Is there anyway to stop this or a way to add this Line design to the graph so its always in place?
Thanks
- Anonymous4 years ago
Hi Mouseman85
I think you build a cluster bar chart and then add a line shape in Y axis. If you change the value in Axis, your visual will shift that will cause line chart in wrong postion. This may caused by the value change or Y axis in your visual. Power BI doesn't support you to set your line shape postion dynamiclly. You may need to move the line shape manully.
I think you can try to build a Constant line in Analytics, set the value = 0, Line style = Solid.
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandakSuper User
Mouseman85 , Not very clear.
1. Sort on Axis. If need use sort column for axis column
2. If needed enable option "Show item with no data", that will show all values of axis
- AnonymousNot applicable
Hi Mouseman85
I think you build a cluster bar chart and then add a line shape in Y axis. If you change the value in Axis, your visual will shift that will cause line chart in wrong postion. This may caused by the value change or Y axis in your visual. Power BI doesn't support you to set your line shape postion dynamiclly. You may need to move the line shape manully.
I think you can try to build a Constant line in Analytics, set the value = 0, Line style = Solid.
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.