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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
KelvClark
Frequent Visitor

Issue setting target line in graph

Hi All,

 

My last post was marked as Spam for some reason so I'm posting again but without a link to the Power BI file. I'll use pictures instead.

 

I've been having difficulty trying to figure out the relationship between two tables and I'm hoping I can get some help here Smiley Happy

 

I have a sales and target table. The sales table holds granular information and the target table holds top level targets per code and year.

 

The issue I'm having is trying to create a relationship between the sales and target table so to have a line graph with the sales line and a target line. 

 

From the picture below you can see the item codes are displaying correctly but the target line is straight. It seems to be adding them all together so it is alwats 123000.

Capture1.PNG

 

I have added the Code and Year tables to create a one to many relationship as previously it was many to many.

Capture2.PNG

 

This is the data contained within the tables. Sales table then Target table.

Sales TableSales TableTarget TableTarget Table

 

I would be hugely grateful for any assistance in this.

 

Kind regards, Kelvin.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@KelvClark,

Did you use Year column from your Year table as your axis?

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

@KelvClark,

Did you use Year column from your Year table as your axis?

Thank you so much for your reply. 

 

I wasn't using the code and year from the inndividual tables. I have done so and now have the desired results.

 

Many thanks.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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