title: Power BI many to many issue to resolve
body: <p>I realize that Power BI does not resolve many to many relationships. I am new to database and Power BI and was wondering if there is any way to resolve the problem I am having. 
  I am pulling a sales table from my database which give me </p>
  
  <pre><code>Starting_Date_of_week   Actual  ShipGrp
  </code></pre>
  
  <p>I have 5 shipgrps so I am getting 5 rows for each week.</p>
  
  <p>Now I hve a budgeting excel, which has 1 row for each week, but 5 different columns for each group. So I pivoted the table to have the table similar to my query table. But now the tables are not joining. Are there any ways for these tables to join. Am I missing out anything or any better way to create visualizations for these tables to interact with each other in the charts?</p>
  
  <p>I want the filters to interact between charts and the groups, and basically compare the budgeting excel and the actuals in the database. </p>