cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors