Graphing data where axis in one table, but values in another

[Anonymous]

I am trying to graph data across two tables. One table has Customer Names and Contract IDs (repeating for different contract components), and the second table has Contract IDs (unique) and Contract Revenue. I have linked the two tables by a 1:many relationship from table 2 to table 1. However, when I try to create a simple bar graph with the x-axis as Customer ID and the y-axis as Revenue, I get every bar as the same height. Does anyone know how I can fix this?

[Ashish_Mathur]

Hi,

Why is Table 1 required.  Your requirement should simply get fulfilled by creating a visual from Table 2.

[Anonymous]

I need to graph by Cusromer Names, which are only in Table 1. Sometimes multiple contracts roll up to 1 customer. Which is why I need table 1.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.