Forum Discussion
Error: Can't determine relationships between the fields
jmerunka,
What fields of these three tables you use to create visual? In your scenario, you may need to combine required fields using Merge Queries feature in Query Editor of Power BI Desktop, then create visual using these fields.
There is a similar thread for your reference.
http://community.powerbi.com/t5/Desktop/Error-Can-t-determine-relationships-between-the-fields/td-p/173492
Regards,
Lydia
Stacked bar chart
Y- axis - 1 field - Dim_salesperson.Dim_sales person name
Measures - 2 fields - sales.price EUR , opportunity.total weighted EUR
Legend - 1 field - Dim_Status_calc.Dim_Status_calc
The desired state is that each shown measure should have two different colored bars based on its Dim_Status_calc.Dim_Status_calc.
Measures in chart
sales.price EUR - two colored bars ( where Dim_Status_calc = 1 or where Dim_Status_calc =2)
opportunity.total weighted EUR - two colored bars ( where Dim_Status_calc = 3 or where Dim_Status_calc =4)
(Visual is based on current model which uses 3 measures instead of 2 and Dim_Status_calc =4 is filtered out)
jmerunka,
In your visual, I don't see any error message, could you please post expected result in table format? And is there any possibility that you can share the PBIX file for me the check?
Regards,
LydiaVisual in my previous post was OK, because the link via Status calc was removed:
a diagram with a removed link
When link is activated again:
a diagram with an activated link
it breaks for opportunities:
status_calc for opp
status_calc for sales
where Actual = status 1 and Backlog = status 2, Pipeline = status 3 and Unknown = status 4
A chart for Opportunities should not be empty and should be combined with sales in a stacked bar chart.
I am not sure if I can post any real tabular data here. I am still in a trial period. :)When I link Dim.Status_calc with :
1) opportunity - it works
2) sales - it works
3) opportunity & sales - it does not work