Why can't I produce my visualizations the same way as in another Power's file?

[Ayupchap]

Hi there

OK hopefully this is not super tricky to explain.  I created a relationship between two datasets in powerbi (used salesforce objects)  The data came out great!  I wanted to add the same visualizations to another powerbi file so imported the missing dataset as I normally do, linked them exactly the same way.  I went to produce the visualization and its just not working, whatever I try.

This is an image of the visualization that I want to achieve

Heres its relationship

Now heres the bad graph made the same way 

Heres the relationship.  tehres others here but the link is exactly the same

if anyone can help I'd really appreciate it I' just can't work it out.

[CahabaData]

your bad visual has the vertical Y axis is in % and therefore max is 100; while in your original it is an absolute value up to 250.

[Ayupchap · Accepted solution]

OK so after a while I worked out the issue.  Thanks for everyones tips but the issue was in thre relationship pane I had to double click the connection line and change the relationship direction to both, that fixed it!  Not sure how I worked that out but glad I did.

[Phil_Seamark]

Hi @Ayupchap

The field you drag to the Axis needs to have a relationship (or be in the same table) to the fields you drag to the axis.

Can you please let us know the TableName.Field for what you have used in your bad graph.  We can then suggest maybe a better alternative,