Forum Discussion
Line on chart
Hi,
I am still new to PowerBi, so am likely to be missing something very obvious!
I have a line and stacked column chart with a line value set, which all works fine, however, the line doesn't go right across the visual - it starts half way across one bar and end half way across the end bar. If there is only 1 bar it just appears as a dot. I assume this is a formatting change, but I can't see it! Thanks everyone 🙂
5 Replies
- Pragati11Super User
Hi mattmickeyj ,
You line on your chart seems to be representing a single value for every bar on your x-axis.
Is the format of column that you are represneting as a line is same as that the column represneted as a bar?
Because your y-axis shows percentage values.
Also, are you using any summarisation on the metric used to represent line?
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
- amitchandakSuper User
mattmickeyj , you have options under analytic pane.
https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane
or you can use like clustered chart and have line of your choice
- mattmickeyjFrequent Visitor
Thank you both. How do I add a line of my choice in the clustered chart please?
- Pragati11Super User
HI mattmickeyj ,
You can refer following link:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati