Forum Discussion
Error: Can't determine relationships between the fields
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,
Lydia
Visual 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 workjmerunka,
It is difficult for us to provide you suggestions without PBIX file. You can make a PBIX file with dummy data, and send me the PBIX file via Private Message.
Regards,
Lydia