Comparision Visual

[Anonymous]

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.

[amitchandak]

@Anonymous , Use secondary axis

[Anonymous]

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.

[AllisonKennedy · Accepted solution]

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

[Fowmy]

@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 🙂

YouTube, LinkedIn