title: Power pivot many to many relationship between two tables
body: <p><img src="https://i.stack.imgur.com/5uKDA.png" alt="enter image description here"></p>
  
  <p>As you can see from the image i have a one-to-many relation ship between these two tables. BUT i want to make it soo its a Many-to-many. Im using AssetID as the key for these relationships.
  Any ideas on how i could create this??</p>
  
  <p>The reason whu need it as a Many-to-Many as im using this in powerview and using Column headers as sliders. An example of this would be if i was to select Windows 7 in the tblOperatingSystem slider the slider which i use for tblAssets would only display what is relevant to windows 7, where as i want to be able to do the opposite and select in tblAssets silder and only the OS would appear which is relevant in the tblOperatingSystem slider </p>
  
  <p>I have already Tried to create a new table which just has AssetID and then connect tblAssets and tblOperatingSystem to it but this method doesnt work for the sliders.</p>
  
  <p>Any ideas round this?</p>