Forum Discussion

jmerunka's avatar
jmerunka
Frequent Visitor
8 years ago

Error: Can't determine relationships between the fields

Hello all, I have been given a task to create a report based on our company source data in Power BI Unfortunatately my company has an absence of proper DWH and BI software and reports are therefo...
jmerunka's avatar
jmerunka
Frequent Visitor
8 years ago

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. :)







 

jmerunka's avatar
jmerunka
Frequent Visitor
8 years ago

When I link Dim.Status_calc with :

1) opportunity - it works
2) sales - it works
3) opportunity & sales - it does not work

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    jmerunka,

    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