Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |