Forum Discussion

chenko90's avatar
chenko90
Frequent Visitor
6 years ago
Solved

Forming relationships with different data

Hi,  I am trying to create some relationships in my report and am running into issues. I have three different excel sources that i am using in one report. I need to be able to filter them all by mon...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago
    Hi chenko90,

    Create. Calendar table and a department table with unique values then use those table to relate all other tables that way you will have 1 to many relationships and will be able to make all the calculations on your model.
edhans's avatar
edhans
Community Champion
6 years ago

If Power BI is forcing it to many-to-many then that means you don't aren't connecting two fields that are unique in one of the tables. Can you post a screenshot of your model, and a bit more details on what you mean when you say you filter on two columns and it won't let you? Filtering on 2+ columns shouldn't be an issue.