Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
ChocoGanache
Frequent Visitor

Line chart with 2 Y-Axis based on data units

‎01-31-2021 09:05 AM

Hello I've been searching for a way to display line chart with 2 Y-Axis based on a certain column (unit) but cannot find any.

 

The required chart is a chart showing product prices with liter products using left Y-Axis and KG products using right Y-Axis. (X-Axis shows dates)

 

Here's sample data.

ChocoGanache_0-1612112405246.png

 

Is it possible? I'm willing to format my data like this, if it helps.

ChocoGanache_1-1612112611043.png

 

Edited: Sorry I forgot to specify that I want Product Name to be in the Legend.

Thank you so much 🙂

 

 

Labels:
Message 1 of 7
1,500 Views
0
6 REPLIES 6
parry2k
Super User
Super User

‎01-31-2021 06:23 PM

@ChocoGanache you cannot have a legend and 2 Y axis.

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 6 of 7
1,400 Views
ChocoGanache
Frequent Visitor
In response to parry2k

‎01-31-2021 08:13 PM

so that's how it is. 
thank you so much for your answers 🙂

Message 7 of 7
1,373 Views
0
parry2k
Super User
Super User

‎01-31-2021 01:40 PM

@ChocoGanache see attached, tweak as you see fit.

 

image.png

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

kgs vs litre.pbix
Message 4 of 7
1,435 Views
ChocoGanache
Frequent Visitor
In response to parry2k

‎01-31-2021 06:13 PM

Thanks so much for your reply. However,could you make it so that the legend says Water, Sand, Juice and Paper instead of KG and Litre? Sorry I forgot to mention that.

Message 5 of 7
1,408 Views
0
VijayP
Super User
Super User

‎01-31-2021 09:20 AM

@ChocoGanache 

Hope this is what yo want

To get second axis , you have to use Secondary values in Line Chart format options. Hope this helps you!

VijayP_1-1612113611834.png

 

 

 

VijayP_0-1612113534253.png

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


answer.pbix
Message 2 of 7
1,473 Views
ChocoGanache
Frequent Visitor
In response to VijayP

‎01-31-2021 06:16 PM

Thanks for your reply however I forgot to mention that I need legend to list product names. 

I can't drag another price column to secondary values well after I put Product Name in Legend well. Sorry for not being clear.

Message 3 of 7
1,405 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

View All