Forum Discussion

PTHops's avatar
PTHops
Regular Visitor
3 years ago

Is a relationship even possible?

Hi there - hoping that this hive can help me get my mind around a relationship issue. I am brand new to Power BI so bare with me, please. - Office 365 -Excel Spreadsheets  (6 individual ones) saved...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I'm no expert, but I wonder a few things:


1) In the current relationship, is it only the FUND CENTRE that is matched? Perhaps we are seeing duplication in Sum of BUDGET because all the FUND CENTRE values are the same (at least in the screenshot)?


2) Have you tried making relationships between each one of the shared fields between those tables? 

 

3) Are the data types of these fields set correctly and identical between the two tables?

PTHops's avatar
PTHops
Regular Visitor
3 years ago

Brenden - thank you for the questions!

 

1. Yes it is.

2. When I try to make relationships between other fields I get an error that I can't create create a Many to Many with cross filtre direction set to both, which is what I feel I need?

3. Yes they are.

 

Maybe I am just not understand the correct relationship between the tables. I had thought I needed the manay to many going both ways. I stand to be corrected and educated 🙂