Forum Discussion
Comparision Visual
Hello,
I have a graph which shows Price and quantity on it as per quarters. I have visualised it using "Line and clustered column chart" but the data looks very skewed. Is there any visual where i can put quantity on seperate axis altogether, so that data in visual looks clear. Right now my visual looks like this:
Kindly help.
- As Fowmy said you are already using the correct visual, you just need to click on the formatting icon to turn on the secondary axis. See this link to reference the section that explains how to do this: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart#add-titles-to-the-axes
4 Replies
- FowmySuper User
Anonymous
You can use Line and Clustered Column Chart:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
- AllisonKennedyCommunity ChampionAs Fowmy said you are already using the correct visual, you just need to click on the formatting icon to turn on the secondary axis. See this link to reference the section that explains how to do this: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart#add-titles-to-the-axes
- AnonymousNot applicable
Hello Priyanshu,
Try adjusting the scale on Y axis for this chart and also remove the data lables from columns(use tool tips rather), it would look much cleaner. Also you can try puting your values in a stacked column chart or Clustered column chart for quantiy and price.
- amitchandakSuper User
Anonymous , Use secondary axis