The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Folks,
is it possible to plot 2 lines on a line graph in power BI but against different axis . So I want to place price per unit (small value) against quantity sold (big value) so want to be able to use different scales. Also, I have a table showing products down the left hand side and sales per month along the top. When I try to convert this to a simple line graph it moves the products to the x axis and the months to the y - I cant see an easy way to swap these around..
Any help much appreciated.
Rgds
Richard
Hi @Richard76,
It seems that you want to a line chart with two lines and add a secondary axis which is not supported in Power BI currently.
You could vote this similar idea here and add your comments there to improve Power BI and make this feature coming sooner.
For the workaround, you could use Line and Stacked column chart which has two axis.
Best Regards,
Cherry
Thanks Cherry - is there an easy way to swap the axis so the months are along the bottom ??