Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Dashmir
New Member

Graph with multiple series

Context
I have two tables. I use table 2 to divide the value by the quantity.

Table 1 Column Names

RefCodeFood?ClassCategory HeaderCategoryValueYearSource
Testk00022Chocolate0SweetSalesQuarter 11,000.002016-17XX


Table 2 Column Names 
Code is unique.

CodeQuantity
k00022100


Measure
In PowerBI I create a measure to divide Value / Quantity.

Graph
X axis = Year

I want to have the graph have two lines. One line for a particular food type e.g. chocolate and the cost per year.
I also want to have another line which is the averge of the value/quantity per class. So for blueberry which has a class of fruit, I want to have the average of fruit as a second line.

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi @Dashmir ,

 

Is your issue solved now?If not,could you pls share some sample data with expected output for test?

 

Remember to remove the confidential information.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

v-kelly-msft
Community Support
Community Support

Hi @Dashmir ,

 

Create a column as below:

quantity = LOOKUPVALUE('Table (2)'[Quantity],'Table (2)'[Code],'Table'[Code],0)

And you will see:

v-kelly-msft_0-1619423868553.png

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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