Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Relationships Between Two Or More Fields

 

Hi, 

 

Can anyone explain to (in simpleton terms) the issue we are experiencing? Why are you unable to display fields from multiple sources/tables in a single table visualization element on a PowerBI report?  (Seems to work on Matrix, but we would ideally be able to pull in PIN and WBS name not just PIN and then dates)

 

We reference everything by a PIN lookup table which contains all PINs with no duplicates, this then links to each of the fact tables (I have a separate table for Baseline Dates, Forecast Dates, Actual Dates). Why i try to add all dates to a single table visualization I get the error "power bi can't determine the relationship between two or more fields"

 

My concern is we reference literally everything by a the PIN field so I'm concerned that as we add more elements to our data model we will encounter more issues like this

 

The simplest solution I can see is just merging my three date tables, but should I need to?

 

Thanks in advance for reading/responding

Need Help

2 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Jturv,

    You could try to set relationship to "many to many" and direction to "both"  to see whteher it work or not. In addition, you also could try to use crossfilter to see whteher it work or not. You could refer to this post  for details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, thanks for the response. 

       

      Many to Many does not seem possible, as the PIN table has unique values (all of the PINs we currently have on our system)

       

      This is what links to the 3 separate fact tabls for different dates (baseline, forecast, actual)

       

      I changed the cross filter direction to both and still get the same issue, can't be displayed together in a table but will work in a matrix. 

       

      I'm considering just merging the 3 tables but all the guidance I have read said this should not be needed and everything can be done through relationships?