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: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
MichaelaMul
Helper III
Helper III

Need Help- Want Line Graph with 2 Y-Axis Values with Legend

‎04-22-2025 01:02 PM

Hello,

 

I am wondering if there's a way to make a simple line chart with the week as the X-Axis and the Y-Axis the Volume Sales and Volume Sales YA by Product. So you can see Private Label, Product S and Product A's Volume Sales currently vs YA represented in a graph. Is there a way to do that with my data formatted the way it is? Below is a sample of my data:

WeekProductGeographyVolume SalesVolume Sales Year Ago
1/5/2025Private LabelTotal US1030505.7991385873.44
1/5/2025Product STotal US786422.8968860653.3125
1/5/2025Product ATotal US811967.951923289.321
1/12/2025Private LabelTotal US1054297.3971319795.141
1/12/2025Product STotal US892892.8155940383.4283
1/12/2025Product ATotal US849777.1346928970.5459
1/19/2025Private LabelTotal US1044057.3511330293.105
1/19/2025Product STotal US850589.306970618.1928
1/19/2025Product ATotal US881846.0282919173.2595
1/26/2025Private LabelTotal US1000397.7331312970.696
1/26/2025Product STotal US793841.3918812572.3142
1/26/2025Product ATotal US792477.1022856865.8128
2/2/2025Private LabelTotal US998050.38421345675.773
2/2/2025Product STotal US703026.8167857312.1127
2/2/2025Product ATotal US830741.2417823663.1697
2/9/2025Private LabelTotal US1012625.551341140.981
2/9/2025Product STotal US736385.0653825559.4162
2/9/2025Product ATotal US892068.1942859961.017
2/16/2025Private LabelTotal US967057.58011276585.822
2/16/2025Product STotal US689564.1237731558.6706
2/16/2025Product ATotal US771205.3933804470.107
2/23/2025Private LabelTotal US1027996.7161319725.24
2/23/2025Product STotal US751156.6292885083.2556
2/23/2025Product ATotal US745708.4607795517.6432
3/2/2025Private LabelTotal US989275.84361294280.37
3/2/2025Product STotal US882588.3508818221.0232
3/2/2025Product ATotal US762653.9129913036.4634
3/9/2025Private LabelTotal US1029216.2391311647.766
3/9/2025Product STotal US798849.6613789010.6178
3/9/2025Product ATotal US761505.3784867262.8931
3/16/2025Private LabelTotal US1017941.6351289207.023
3/16/2025Product STotal US681379.6733730180.7158
3/16/2025Product ATotal US798008.6329863919.2656
3/23/2025Private LabelTotal US1022142.3791263122.308
3/23/2025Product STotal US663213.0574742548.0561
3/23/2025Product ATotal US734417.024903798.0891
3/30/2025Private LabelTotal US1013143.3441202299.588
3/30/2025Product STotal US629124.966798453.1949
3/30/2025Product ATotal US816769.7648868310.451
4/6/2025Private LabelTotal US1040173.5861273351.727
4/6/2025Product STotal US763876.6098837843.4425
4/6/2025Product ATotal US770931.3658817193.7652
4/13/2025Private LabelTotal US1020585.0861233662.724
4/13/2025Product STotal US647557.7009901393.1992
4/13/2025Product ATotal US759620.9725875208.8696
4/20/2025Private LabelTotal US 1246786.346
4/20/2025Product STotal US 737230.2581
4/20/2025Product ATotal US 821931.8933
4/27/2025Private LabelTotal US 1195000.596
4/27/2025Product STotal US 702729.4848
4/27/2025Product ATotal US 882038.8914
5/4/2025Private LabelTotal US 1244301.122
5/4/2025Product STotal US 726309.0621
5/4/2025Product ATotal US 812775.1053
5/11/2025Private LabelTotal US 1187136.712
5/11/2025Product STotal US 736028.6031
5/11/2025Product ATotal US 821801.1293
5/18/2025Private LabelTotal US 1175951.74
5/18/2025Product STotal US 767265.7153
5/18/2025Product ATotal US 794717.889
5/25/2025Private LabelTotal US 1127069.29
5/25/2025Product STotal US 711859.7221
5/25/2025Product ATotal US 824357.0915
Labels:
Message 1 of 5
214 Views
0
1 ACCEPTED SOLUTION
MichaelaMul
Helper III
Helper III
In response to v-bmanikante

‎05-06-2025 11:04 AM

Sorry yes, what I ended up doing was the following: I went into Power Query and unpivoted the Vol Sales and Vol Sales YA data and then made a custom column to CONCAT the product name and the attribute name. Then I used that CONCAT name as the legend and the values column as the y-axis.

Thanks!

View solution in original post

Message 4 of 5
121 Views
0
4 REPLIES 4
v-bmanikante
Community Support
Community Support

‎05-05-2025 02:00 AM

Hi @MichaelaMul ,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,

B Manikanteswara Reddy

Message 5 of 5
126 Views
0
v-bmanikante
Community Support
Community Support

‎05-01-2025 08:34 AM

Hi @MichaelaMul ,

 

May I ask if you have gotten this issue resolved?

 

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Regards,

B Manikanteswara Reddy

Message 3 of 5
145 Views
0
MichaelaMul
Helper III
Helper III
In response to v-bmanikante

‎05-06-2025 11:04 AM

Sorry yes, what I ended up doing was the following: I went into Power Query and unpivoted the Vol Sales and Vol Sales YA data and then made a custom column to CONCAT the product name and the attribute name. Then I used that CONCAT name as the legend and the values column as the y-axis.

Thanks!

Message 4 of 5
122 Views
0
lbendlin
Super User
Super User

‎04-22-2025 01:15 PM

You can either have a legend, or you can have two Y axis values, but not both.

 

One option is to use Small Multiples

lbendlin_0-1745352689476.png

 

The other option would be to modify your data to change the product column to include the CY/PY distinction

lbendlin_1-1745352892926.png

 

I kinda prefer the small multiples.

 

 

two Ys and a L.pbix
Message 2 of 5
198 Views
0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All