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

Question

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 · Answer

Hi,
Why is Table 1 required.&nbsp; Your requirement should simply get fulfilled by creating a visual from Table 2.

anonymous · Answer

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 · Answer

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

Forum Discussion

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

3 Replies

Related content

Power Query LookUp in another table

[PowerQuery] add (same) column from another table

Fabric graph

How to add another column from another table?

merge or update/insert lakehouse table from another lakehouse table